Hi again,

Am Mon, 8 Dec 2014 16:48:08 -0800 (PST) schrieb GWC:

How can I retain the carriage-returns if I type =LEFTA(A1,60) in column B1 and =mid(a1,61,100) in column C1?

you can also work with TextToColumns. Set ")" as separator and choose in
step 3 B1 as target cell. Now you have your substrings in B1:D1. Then
write in A1:
=B1&CHAR(10)&C1&CHAR(10)&D1
Copy A1 and paste special as values that you can delete B1:D1


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional