eliminate dashes in upc's

[learnallican1124]

How do you format to eliminate dashes in a cell that numbers example a upc:

7-67774-54123

 

[JP]

If the UPC is in cell A1:

=SUBSTITUTE(A1,"-","")

HTH,
JP

 

[Gord Dibben]

Maybe simply Edit>Replace

What: -

With: nothing


Gord Dibben MS Excel MVP

 

[Shyam Ramachandran]

CTRL F > Click REPLACE tab > In the Find what box add "-" > Leave the Replace
With Field blank > Click on "Replace ALL"

All the dashes will be removed. You can format the number once the dashes
are removed