Checking characters , non-printable etc.

D

dhstein

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.
 
P

Pete_UK

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
 

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

Top