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