Monday, 28 April 2008
A little known feature of Microsoft Excel is the ‘text to columns’ option under the Data menu which allows information in a cell or range of cells to be split into columns. Typically we find this tends to occur on exported lists of address information or such like.
For example if you have a list of information in a cell or a column of cells:
You might want to split the data into columns to make it easier to work with:
This can be achieved by:
- Highlighting the Column (or Columns) containing the information you want to split
- Click on the Data menu
- Click “Convert Text to Columns”
- Select Delimited (there is also a fixed width option that allows you to split by character positions) then click Next
- Make sure that Comma (or whatever other delimiter you have) is checked then click Next
- Click Destination and choose an empty Column to the right of the data
- Click Finish
- All Done
Related
- Excel Print Comments
- Corrupt text display in Acrobat and Terminal Services
- PCL by hand
- Tuesday Morning
- ASP: Teaser Text



Thank you for your info. However, I want to do exactly the same thing in my PDA phone using Excel Mobile 6.1 and I cannot find such function there. Please help. Thanks again.
Information was great. Can you have the destination on a different worksheet?
First time I’ve had a look up that gave me the tab, then the section I needed to use. I didn’t even have to read what you wrote! You’re a genius! Thanks for not embedding the tab at the end somewhere so I had to read. I got it in less than 10 seconds from when I opened the page! Thanks!
Thank you! It was so easy!!!