eliminate dashes in upc's

L

learnallican1124

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

7-67774-54123
 
S

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
 

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

Using FIND to highlight text (with dashes) 4
Need Help Combining Records with Duplicate in some fields 0
Removing Dashes in Excel 4
UPC Numbers 1
FormCode - Converting Type-E UPC to Type-A (barcodes) 2
VBA Code for converting Type-E UPC to Type-A (barcodes) 1
Get rid of Microsoft AutoUpdate 0
How do I format cells as custom and keep text formatting? 2

Top