unusual characters

G

george

I've got an excel file that contains several unusual
characters. These look like square boxes, and they screw
up some code that I've written to process my data.

I can't do a find and replace because I don't know what the
character is and I can't paste it. If I paste it into
notepad, it looks like 2 double quotation marks on seperate
lines!

Any ideas on what these are and how to get rid of them?

Thanks,
George
 
P

Peo Sjoblom

Try

edit>replace, in the find what box hold down alt while typing 010 on the
numpad, release alt
if you want to replace them with a space type a space in the replace with
bow otherwise leave it empty
If that doesn't work try with 013

--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom
 
B

Ben Kovar

Hello Peo,

When I typed what you suggested and pushed the replace all
key, I got a message that indicated that the character did
not exist. However, when I put the following formula in
the adjacent cell, it removed the square:
 
B

Ben Kovar

Whoops, the formula was as follows:
=substitute(cell,char(10),"")

Any other thoughts on how to use replace to get rid of
these?

Thanks,

Ben
 
P

Peo Sjoblom

What can I say, it works for me replacing carriage returns (that's what they
are) using edit>replace
Make sure you don't have anything checked in match case or match entire cell
contents

--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom
 
P

Peo Sjoblom

Also make sure you type 010 and not 10 on the numpad holding down alt

--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom
 
B

Ben Kovar

Hello Peo,

I got it to work! I missed the fact that the numbers had
to be typed on the numpad in your earlier message. I had
used the numbers above the letters by mistake.

Thanks!!!!

Ben
 
G

george

Cheers Peo, I've got it to work as well, but its strange
because it can only find these values if I do it first
thing after opening the spreadsheet, if I try and do it
later then it can't find these values??!

There are still some characters being displayed, so I
suspect these are other non-printing characters like tabs
or something, again they appear like squares. Fortunately
they don't affect my program, but is there any tools I can
use to find out what their codes are, or is there any way
that I can prevent Foxpro from exporting them??

Cheers,
George
 
Top