The article looks at joining text in multiple cells and columns using concatenate function and other smart ways.
Tag Archives: Excel
Smart Tips on MS Excel 2007 – How to use Subtotal function?
Microsoft Excel has numerous functions but the issue is about knowing which function to use in the shortest time We began with a few smart tips in the initial posts which looked aspects like shortcuts and basic functions in at Microsoft Excel 2007. We would continue with the same and gradually address some more text, [...]
3 easy steps to convert PDF to Excel or Word online for FREE!
Just came across Nitro PDF Software site and found their new online tools to convert your PDF files to Excel or Word for FREE. Nothing much to do – no software to download – these are the following 3 easy steps to follow: 1. Select PDF file to convert 2. Choose Converstion type – .XLS [...]
Using Vlookup for multiple sheets in Excel 2007
Vlookup is one function which is widely used across the excel users. However, for those who are beginning to use Excel, this post would give a few tips on how to use Vlookup across multiple sheets. So, before we begin, a brief into about what vlookup does. The function is used to retrieve values corresponding [...]
List of useful MS-Excel resource sites
Internet is full of websites which provide tips and information on Microsoft Excel but since they are stand alone in nature it gets difficult to get a set a questions or queries answered under one roof. The search for the right resource can be elusive and can be a pain many a times So, we [...]
How to create and work with tables? – MS Excel 2007 Tips
Excel 2007 has come up with several customized features and one of them is Tables. Working with tables has been much more appealing and customized for its users in the newer version. To give you a glimpse, let’s work with a set of values. Enter a few values in an excel sheet as follows
How to find values in a range in a sheet? – MS Excel 2007 Tips
Filling or finding values in a sheet pertaining in a range can be accomplished easily using conditional formatting. The previous post spoke about finding duplicate values in a sheet. This post talks about this topic further.
How to find repeated values in a sheet? – MS Excel 2007 Tips
For those of you who wish to find repeated values in a sheet full of numbers, Using CTRL+f would yield the desired value one at a time and if the sheet is full of data then you are up against some task! To find values simultaneously there is another simple way in Excel 2007- Conditional [...]
Smart Tips on MS Excel 2007 – How to create a series?
For those of you who have used MS Excel 2003, the easiest way to creating a series comprising of continuous values would be to enter first two or three values of the series and use the drag handle to fill the remaining values of the series, right?
Smart Microsoft Excel 2007 Shortcuts
For all those of you who are used to working with shortcuts in MS-Excel , Office 2007 would appear to be with a little makeover in terms of the shortcuts and layout! Among the more often used shortcuts, some of them have been provided in this post.