Excel Tip # 1 – Text to Columns

Published:

[vc_row][vc_column][vc_text_separator title=”Excel – Text to Column function” title_size=”24″][/vc_column][/vc_row][vc_row][vc_column width=”2/3″][vc_column_text]How often have you come across the following issue. You have a column in a spreadsheet that contains data that you need to separate out. It could be that each cell contains the Full Name of a person and you need it to be broken out into First Name and Surname. The cell might contain a postal address that you need broken out into Address Line 1, Address Line 2, Town, County etc.

If you’ve ever found yourself copying a column and then deleting information from it to get what you need then this tip is for you. Before I learned it when I had a cell with a Full Name that I needed to be broken out I used to copy the full cell and then delete the surname from the first column and the first name from the second column to leave me with what I required. Not only was this time consuming it was soul destroying when there were hundreds of records in the list.

The is an Excel function called ‘Text to Columns’ that makes this process as simple as a few mouse clicks. Hidden under the Data menu tab this powerful function will save you time and you will never find yourself copying and deleting cell contents again.

To see the function in action click the video icon or just follow the steps outlined below.[/vc_column_text][/vc_column][vc_column width=”1/3″][/vc_column][/vc_row]