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.