The title pretty much summarizes it. I have been messing around tryin
to get this to work all day and the solution to me seems to be to us
the 'LEN' command to get the number of characters pasted into the cel
and then subtract 250 from that number. If the result is > 0 the
print all text over 250 characters to the cell directly to the right o
the first cell.
I don't know the syntax for it but here is the process I am looking fo
help on:
if (LEN - 250) is > 0 then (use the right command and the result o
(LEN-250) to print the remaining text to the cell directly to the righ
of the first cell)
I would greatly appreciate any help anyone can give me on thi
headache. :confused
--
Hobart00
-----------------------------------------------------------------------
Hobart007's Profile:
http://www.excelforum.com/member.php...fo&userid=3634
View this thread:
http://www.excelforum.com/showthread.php?threadid=56124
Similar Threads
