| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Why text to columns is not available when there is mulipule line .
When converting text to colums for cells have multiple line breakers, the
text wizard pulls only the text before the first line breaker when selecting Delimited function? Is this a known issue? How would I correct it? |
|
#2
|
|||
|
|||
|
I assume you mean you have a carriage return (alt + enter),
select delimited, click next, check other delimiter and hold down alt while typing 010 on the numpad click finish -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "Bing" wrote in message ... When converting text to colums for cells have multiple line breakers, the text wizard pulls only the text before the first line breaker when selecting Delimited function? Is this a known issue? How would I correct it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel, using line wrap with text, some cells will appear as ##. | Excel Discussion (Misc queries) | |||
| text from one column into multiple columns | Excel Discussion (Misc queries) | |||
| Text import out of line? | Excel Discussion (Misc queries) | |||
| Adding a text label to a line. | Charts and Charting in Excel | |||
| Forcing text onto new line in cell | New Users to Excel | |||
Linear Mode
