Thread
:
How do I remove hyphens from a product UPC?
View Single Post
#
3
Gary L Brown
Posts: n/a
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.
Reply With Quote