Checking characters , non-printable etc.
 

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.

Checking characters , non-printable etc.
 

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.