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