Thursday, February 3, 2011

Text to Columns - Excel 2007

A worksheet containing data in one column; you may find it necessary to separate the cell contents into two columns. In the image below, you maybe required to separate the first and last names into two columns, when using the data for a mail merge.


1.  Select your data, in this example A2:A10

2.  From the Data tab, within the Data Tools group, click on Text to Columns.

Text to Columns button






3.   From the Convert Text to Columns Wizard dialog box, select Delimited and click on Next.

4.  From the Convert Text to Columns Wizard dialog box, select Space, clear tab check mark and click on Next.










5.  From the Convert Text to Columns Wizard dialog box, select Text, click on the second column of data, select Text and click on Finish.


In the image below, finished results show data moved last names into it's own column.












Excel is awesome- it helps you work smarter, not harder.  Can this tip help you?