| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
=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. |
|
#3
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I remove all hyphens in a column without retyping? | Excel Discussion (Misc queries) | |||
| Percentages | Charts and Charting in Excel | |||
| how do i remove hyphens from between numbers | Excel Worksheet Functions | |||
| How do i remove the hyphens between numbers without having to edi | Excel Discussion (Misc queries) | |||
| Which function(s)? | Excel Worksheet Functions | |||
Linear Mode
