Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
splitting cells
I use Excel 2002 with XP Pro SP3. I seem to remember that in Excel '97 you
could split a cell, but I can't seem to be able find a way to do this in Excel 2002. Am I missing something here or can't you split a cell into two smaller cells anymore? Didn't you used to be able to do this in Excel 97, or is my memory not what it once used to be? Mike |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
splitting cells
The latter, you cannot split a cell in 2 smaller.
You can parse out text (or numbers) that it is in once cell into multiple cells where you would use either datatext to columns or text formulas. -- Regards, Peo Sjoblom "Bitter Clinger" wrote in message ... I use Excel 2002 with XP Pro SP3. I seem to remember that in Excel '97 you could split a cell, but I can't seem to be able find a way to do this in Excel 2002. Am I missing something here or can't you split a cell into two smaller cells anymore? Didn't you used to be able to do this in Excel 97, or is my memory not what it once used to be? Mike |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
splitting cells
Hi,
What you are asking to do can't be done in Excel and has never been possible. You may be remembering Word, which can split a cell into two smaller cells or Apple puts out a spreadsheet that does allow splitting of cells, if my memory serves me correctly. -- Thanks, Shane Devenshire "Bitter Clinger" wrote: I use Excel 2002 with XP Pro SP3. I seem to remember that in Excel '97 you could split a cell, but I can't seem to be able find a way to do this in Excel 2002. Am I missing something here or can't you split a cell into two smaller cells anymore? Didn't you used to be able to do this in Excel 97, or is my memory not what it once used to be? Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
splitting cells | New Users to Excel | |||
Splitting cells? | Excel Discussion (Misc queries) | |||
Splitting cells - please help! | Excel Worksheet Functions | |||
splitting cells | Excel Worksheet Functions | |||
Splitting Cells | New Users to Excel |