D Dave Peterson Apr 30, 2008 #4 If you're using xl2003 and below, you can select your single column Range and click on Data on the menu bar. Then click Text to columns. You'll be prompted to find out how you want to split the data--either by a delimiter or by fixed column widths.
If you're using xl2003 and below, you can select your single column Range and click on Data on the menu bar. Then click Text to columns. You'll be prompted to find out how you want to split the data--either by a delimiter or by fixed column widths.
G Gary''s Student Apr 30, 2008 #5 It is a way of splitting a cell. Lets say A1 contains: cat,dog,mouse,bird all in one cell. Click on this cell and pull-down: Edit > Text to Columns... then tell the Wizard what you want to do
It is a way of splitting a cell. Lets say A1 contains: cat,dog,mouse,bird all in one cell. Click on this cell and pull-down: Edit > Text to Columns... then tell the Wizard what you want to do
