How do I separate wrap text in excel spreadsheet?

  • Thread starter separate wrapped text
  • Start date
S

separate wrapped text

I work with mailing lists in Excel, and sometimes I run into wrapped text
that when I unwrap it, it results in line breaks (little boxes) within cells
that were wrapped.
What I'd like to know is whether there's a way to use that line break as a
delimiter
to separate the data (i.e. two address lines) into separate columns.
 
R

Roger Govier

Hi

Mark the column of text>Data>Text to columns>delimited>Next>Other>then in
the box next to other type Alt+010>Finish

Ensure that the 010 is typed on the Numeric keypad, NOT the row of numbers
at the top of the keyboard.
 
G

Gord Dibben

CTRL + j also works to enter the linefeed character.


Gord Dibben MS Excel MVP
 

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

Grow/Shrink Text gradually from slide to slide 0
How do I stop text from disappearing when I wrap text in Excel? 0
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Disable automatic text wrap? 2
How do I set focus (and select text) on a text box on a modeless userform? 0
how to autocreate separate emails for defined ranges in spreadsheet 0
Converting excel to PDF, single page converts to multiple HELP! 1
When I wrap text, the text disappears unless I click on the cell 0

Top