identify little squares for Alt Enter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm pulling bulleted text from a PowerPoint into an Excel table. My text
comes in fine but need to remove the small little squares after each line and
allow the next line to move down. Can anyone get me started on this?
 
If you want the cell's text to wrap, just select your range and

Format|cells|alignment tab|check wrap text.

The square will disappear and you'll see the text wrapping.
 
Sometimes you may see two squares (a line feed and a carriage return) in
which case you will need to use this formula to do what you asked:

=SUBSTITUTE(A1, CHAR(13) & CHAR(10), CHAR(10))
 
You must log in or register to reply here.

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

litter square caused by ALT + Enter 1
Form Textbox Mulitline question 3
Square before beginning of a new line 3
Macro to remove squares from cells 7
Find and Replace alt enter 3
Small square in the cells of CSV files - Text to column 4
Moving shapes around excel using vba 4
identifying the character represented by a square box 2

Back
Top