identify little squares for Alt Enter
 

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?

identify little squares for Alt Enter
 

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.

DB wrote:

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?

--

Dave Peterson

identify little squares for Alt Enter
 

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))

"DB" wrote:

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?