Hi
One suggestion, you can doubleclick on the edge of the column to make it
automatically fitt, and then manually split the text.
You can also mark the sheet (ctrl+ A) and then format<cells< adjust and then
"split text". Sorry, danish...don't know what it says in the english verson.
If it's only one cell don't mark the whole sheet but format<cells< etc.
Hope it's what you meant.
THANKS
--
Therese


"Doug Benjamin" skrev:

>
> What I want to do is split up a cell of about 25-60 characters into two
> cells without ending up with words cut in half or duplicated words. I
> want the first 30 characters in the first cell and the rest if any in
> the second cell. Any Ideas?
>
>
> --
> Doug Benjamin
> ------------------------------------------------------------------------
> Doug Benjamin's Profile: http://www.excelforum.com/member.php...o&userid=33407
> View this thread: http://www.excelforum.com/showthread...hreadid=532285
>
>