Does anyone know how to convert UPC's?

G

Guest

I have a bunch of UPC's listed individually down a column in my excel
document, but they are in formats such as "0-2115-0296-2-9", does anyone know
a way; whether a function or otherwise, to convert it into a number such as
02115029629. We have a business application that cannot read the UPC with
the hyphens in there, only as a full number.
 
A

Anne Troy

Why don't you select the column, then Ctrl+H to Find and Replace. Put a dash
in the Find what, and don't put anything in the Replace box. Hit replace
all.
************
Anne Troy
www.OfficeArticles.com
 

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

Add leading #'s to a value 1
How do I get Excell to recognise 0 at the beginning of a number? 3
VBA tweak to run faster? <--Rookie here 2
How to convert web addresses into hyperlinks 3
Convert a percentage to an hour 2
How to convert text "JAN" into number 1? 9
How to convert into number? 1
Some Error that I can't figure out. 1

Top