Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Does anyone know how to convert UPC's?
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. |
#2
|
|||
|
|||
Does anyone know how to convert UPC's?
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 "threee11" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert decimal degree (lattitude/longitude) into Degree, | Excel Discussion (Misc queries) | |||
"Convert to Number" option disappearing | Excel Discussion (Misc queries) | |||
CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions |