Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"carriage return" as the delimiter?
It seems that any single character can be used as a delimiter, but no
"ALT-Enter". I come across multiple rows within a single cell ALL the time! How do I make "ALT-Enter" my delimiter? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"carriage return" as the delimiter?
If you do the following, it will allow you to use the ALT+ENTER as delimiter:
Choose Data | Text to Columns Select Delimited, click Next Check 'Other', and click in the 'Other' box Hold the Alt key, and on the number keypad, type: 0010 (you won't see anything in the 'Other' box, but that's the code for a line break character) After you let go of the ALT key, you will see how the columns will be split. "EASY QUESTION" wrote: It seems that any single character can be used as a delimiter, but no "ALT-Enter". I come across multiple rows within a single cell ALL the time! How do I make "ALT-Enter" my delimiter? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
"carriage return" as the delimiter?
Instead of using alt-0010 (from the number keypad--not above QWERTY), you can
also use ctrl-j. Office Helper wrote: If you do the following, it will allow you to use the ALT+ENTER as delimiter: Choose Data | Text to Columns Select Delimited, click Next Check 'Other', and click in the 'Other' box Hold the Alt key, and on the number keypad, type: 0010 (you won't see anything in the 'Other' box, but that's the code for a line break character) After you let go of the ALT key, you will see how the columns will be split. "EASY QUESTION" wrote: It seems that any single character can be used as a delimiter, but no "ALT-Enter". I come across multiple rows within a single cell ALL the time! How do I make "ALT-Enter" my delimiter? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Help Importing Text File Using Two or More Spaces as the Delimiter | Excel Discussion (Misc queries) | |||
How can I save Excel am spreadsheet as pipe delimiter? | Excel Discussion (Misc queries) | |||
Counting number of items being added in a formula | Excel Discussion (Misc queries) | |||
Choosing the square character as a delimiter | Excel Discussion (Misc queries) | |||
Changing Export Delimiter | Excel Discussion (Misc queries) |