=SUBSTITUTE(a1,"-","")
--
HTH
RP
(remove nothere from the email address if mailing direct)
"skpdpnt" wrote in message
...
I have to re-format product UPC's from 01-23456-78901-2 to 012345678901.
And, the Concatenate and Left, Mid, Right functions just confused me.
Does
anyone have any ideas? Thanks.
|