If your format is always the same, then one way is to use a helper column
and enter this formula, copied down.....

=LEFT(A1,4)&"-"&RIGHT(A1,2)

then do Copy PasteSpecial Values on that column and you then have a
"real" hyphen between your digits. This way, you don't have to know what
that weird character is.

Vaya con Dios,
Chuck, CABGx3


"tmcleod" wrote in
message ...

I have a column of item numbers that look like they have a dash in them
but it is actually some sort of symbol. ie.... 1000-01, 1000-02. When I
read this file into another system, it does not recognize the "-" symbol
and leaves a blank space. I have tried "replace" but I can't figure out
how to tell it what to replace.


--
tmcleod
------------------------------------------------------------------------
tmcleod's Profile:
http://www.excelforum.com/member.php...o&userid=32912
View this thread: http://www.excelforum.com/showthread...hreadid=527345