Text to columns with carage return as deliminator
 

I have a single column in a sheet wth 4000 rows. The cell contains an address
with the lines seperated by the enter key (carage return) I need to split the
lines to indevidual columns.

Text to columns with carage return as deliminator
 

1. Select the column
2. Pull-down Data Text to columns...
3. Check Delimited
4. Clear the checkboxs and check Other
5. Click in the entry box and, while holding down the ALT key, type 010 on
the numeric keypad
6. Release the ALT key

Finish
--
Gary's Student


"thecuzin" wrote:

I have a single column in a sheet wth 4000 rows. The cell contains an address
with the lines seperated by the enter key (carage return) I need to split the
lines to indevidual columns.