Hi
If it's too complicated, there is a formula that can do it. What caracters
are they?
--
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
>
>