How do I remove hyphens from a product UPC?
 

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.

=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.

or...
=LEFT(SUBSTITUTE(A2,"-",""),12)

If you really did mean to drop the final '2' in your example.

HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"skpdpnt" wrote:

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.