The title pretty much summarizes it. I have been messing around trying
to get this to work all day and the solution to me seems to be to use
the 'LEN' command to get the number of characters pasted into the cell
and then subtract 250 from that number. If the result is 0 then
print all text over 250 characters to the cell directly to the right of
the first cell.

I don't know the syntax for it but here is the process I am looking for
help on:

if (LEN - 250) is 0 then (use the right command and the result of
(LEN-250) to print the remaining text to the cell directly to the right
of the first cell)

I would greatly appreciate any help anyone can give me on this
headache.


--
Hobart007
------------------------------------------------------------------------
Hobart007's Profile: http://www.excelforum.com/member.php...o&userid=36340
View this thread: http://www.excelforum.com/showthread...hreadid=561248