Text to columns with carage return as deliminator

G

Guest

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split data in field on character return 0
counting blank cells within two columns 2
Change all text on Spread sheet 1
Splitting a cell into rows instead of columns 12
Row height setting problem 8
Text to columns 2
Remove the square symbol from spreadsheet 1
Text to Rows 2

Top