Replacing dash in item number

  • Thread starter Thread starter tmcleod
  • Start date Start date
T

tmcleod

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

Try this:

You need to find out what the character really is.

A1 = 1000-01

Enter this formula in B1:

=CODE(MID(A1,5,1))

Now, when you do Edit>Replace use that numeric code as the Find what
criteria, BUT, to enter that code YOU MUST hold down the ALT key and use the
number keypad. Also, the numeric code needs to be entered as a 4 digit
number. If the formula returns a code of, say, 45, you need to enter 0045.

Biff
 
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
 
Back
Top