Why text to columns is not available when there is mulipule line .

B

Bing

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?
 
P

Peo Sjoblom

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)
 

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

Top