Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting Cells
How do I split cells in Excel?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting Cells
Use Text to Columns
-- Gary''s Student - gsnu200782 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting Cells
I have no idea what text to column is, what is it?
"Gary''s Student" wrote: Use Text to Columns -- Gary''s Student - gsnu200782 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting Cells
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. Hezzy wrote: I have no idea what text to column is, what is it? "Gary''s Student" wrote: Use Text to Columns -- Gary''s Student - gsnu200782 -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting Cells
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 -- Gary''s Student - gsnu200782 "Hezzy" wrote: I have no idea what text to column is, what is it? "Gary''s Student" wrote: Use Text to Columns -- Gary''s Student - gsnu200782 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting Cells
Check this out:
http://support.microsoft.com/kb/214261 -- Gary''s Student - gsnu200782 "Hezzy" wrote: I have no idea what text to column is, what is it? "Gary''s Student" wrote: Use Text to Columns -- Gary''s Student - gsnu200782 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting Cells
Thank you so much for the link Gary, it has been very helpful.
"Gary''s Student" wrote: Check this out: http://support.microsoft.com/kb/214261 -- Gary''s Student - gsnu200782 "Hezzy" wrote: I have no idea what text to column is, what is it? "Gary''s Student" wrote: Use Text to Columns -- Gary''s Student - gsnu200782 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Splitting Cells | Excel Worksheet Functions | |||
Splitting cells | Excel Discussion (Misc queries) | |||
Splitting cells? | Excel Discussion (Misc queries) | |||
splitting cells | Excel Worksheet Functions | |||
Splitting Cells | New Users to Excel |