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
 
Back
Top