Hi

Excel can do this in a round-about way, but it needs to know where you
want the line breaks.

If your cell said

John Doe, 123 N. 1st Street, Miami FL 12345

You could use text to columns to split the cell into three and then
concatenate back into one by using

=a1&char(10)&b1&char(10)&c1

Hope this helps

Colin


--
Colin Vicary
------------------------------------------------------------------------
Colin Vicary's Profile: http://www.excelforum.com/member.php...o&userid=10472
View this thread: http://www.excelforum.com/showthread...hreadid=395017