I use Excel daily and I absolutely LOVE it. Here are some more ways to improve your Excel experience.
SPLIT TEXT STRINGS INTO COLUMNS
I am sure most people are not too keen on data capturing. So what happens if you are faced with Excel data that is all typed in long rows, instead of in columns?
In Issue 62 (Do the Splits) I explained how to use formulas to split text lines into columns. I used the formulas LEFT, RIGHT and MID to extract data from a text string. The Text to Columns feature is an even easier way to split text entered in a single cell into columns.
For example, if both first and last names have already been entered into a cell, use Text to Columns to split the names into 2 columns. Simply select the text, and from the Data tab on the ribbon, choose Text to Columns. (It is in the Data Tools group). The wizard will guide you through the simple 3-step process.
COMBINE TEXT FROM MULTIPLE CELLS
Occasionally you might need data in different columns to be combined into one.
For example, if both first and last names have already been entered into different cells, you can combine the names into one cell. To do this you enter a formula with the ampersand symbol (‘&’) between the cell references.
The formula =A1&A2&A3 will add the text in cell A1, A2 and A3 together. If you want to add a space between the text from each cell, enter your formula like this: =A1&” “&A2&” “&A3
NEW TO EXCEL?
If you’ve been reading my Excel tips and nothing makes sense, it is time for a lesson or two! I offer private training - just drop me an email.
My email address is email@example.com
Showing all records: