Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Totaling columns of text in Excel | Excel Worksheet Functions | |||
macro to split text in columns | Excel Discussion (Misc queries) | |||
Text to columns | Excel Discussion (Misc queries) | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Text to Columns from drop down list update | Excel Discussion (Misc queries) |