If you know what the character codes are you can use the SUBSTITUTE
function (applied many times) to get rid of them, or just Find&Replace
several times.

Hope this helps.

Pete

On Feb 25, 10:49*pm, dhstein
wrote:
I'm copying some data from another spreadsheet that someone else created. *It
looks fine on the screen, but when I print it or paste it into Outlook, it
gets messed up. *Specifically, there is one cell which has about 20 lines of
text. *Some of the lines begin with a bullet character. *When it prints some
of the bullets are at the beginning of the lines and some show up near the
end of the line. *Effectively, the format of the text is not what we're
trying to achieve. In Word, I can show spaces and paragraph marks. *Is there
a way to do that in Excel. *I could write a formula and parse out the
characters with the =CODE function but I'm wondering if there's a better way.