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?

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?