H
Hezzy
How do I split cells in Excel?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
Use Text to Columns
H
Hezzy
I have no idea what text to column is, what is it?
D
Dave Peterson
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.
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
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
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
G
Gary''s Student
H
Hezzy
Thank you so much for the link Gary, it has been very helpful.