identify little squares for Alt Enter

[DB]

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]

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

[Andrew]

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