eliminate dashes in upc's

  • Thread starter Thread starter learnallican1124
  • Start date Start date
L

learnallican1124

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

7-67774-54123
 
Maybe simply Edit>Replace

What: -

With: nothing


Gord Dibben MS Excel MVP
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Populate workbook A from Data in workbook B based off criteria in Workbook C 0
FormCode - Converting Type-E UPC to Type-A (barcodes) 2
Removing Dashes in Excel 4
UPC Numbers 1
How do I format cells as custom and keep text formatting? 2
VBA Code for converting Type-E UPC to Type-A (barcodes) 1
vlookup macro 1
Word Dashed line formatting 0

Back
Top