Splitting a cell that has word wrap as the delimiter

  • Thread starter Thread starter Leslie
  • Start date Start date
L

Leslie

Hi -

I have an excel cell that has name on one line, then
alt+enter, address on the next line, then alt+enter,
state on the next line, etc...

I want to split them - I tried using Data Text to
Columns, but I can't figure out to use the Alt+enter as
the delimiter.

Any ideas?
 
Check other and place the cursor in the box, hold down Alt while typing 010
on the numpad, release the Alt key
 

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

Similar Threads

Copy & Paste cell that has alt + enter 2
Splitting out a wrapped text entry 11
"carriage return" as the delimiter? 2
VBA Multiple Line handling with Split() 1
Word wrap issues within merged cells 4
Unicode text and carriage returns 4
How do I unwrap text to columns? 2
can you wrap formula results via a formula eg. Alt Enter 5

Back
Top