Checking characters , non-printable etc.

  • Thread starter Thread starter dhstein
  • Start date Start date
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.
 
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
 
Back
Top