splitting cells

  • Thread starter Thread starter Bitter Clinger
  • Start date Start date
B

Bitter Clinger

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
 
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 data>text to columns or text
formulas.

--


Regards,


Peo Sjoblom
 
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.
 
Back
Top