| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
eliminate dashes in upc's
How do you format to eliminate dashes in a cell that numbers example a upc:
7-67774-54123 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
eliminate dashes in upc's
If the UPC is in cell A1:
=SUBSTITUTE(A1,"-","") HTH, JP On Mar 19, 10:22*am, learnallican1124 wrote: How do you format to eliminate dashes in a cell that numbers example a upc: 7-67774-54123 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
eliminate dashes in upc's
Maybe simply EditReplace
What: - With: nothing Gord Dibben MS Excel MVP On Wed, 19 Mar 2008 07:22:01 -0700, learnallican1124 wrote: How do you format to eliminate dashes in a cell that numbers example a upc: 7-67774-54123 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
eliminate dashes in upc's
CTRL F Click REPLACE tab In the Find what box add "-" Leave the Replace
With Field blank Click on "Replace ALL" All the dashes will be removed. You can format the number once the dashes are removed "learnallican1124" wrote: How do you format to eliminate dashes in a cell that numbers example a upc: 7-67774-54123 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dashes I want Dashes | Excel Discussion (Misc queries) | |||
| What are dashes for | Excel Discussion (Misc queries) | |||
| Dashes in Functions | Excel Discussion (Misc queries) | |||
| Does anyone know how to convert UPC's? | Excel Discussion (Misc queries) | |||
| using dashes and the arrow key | Excel Discussion (Misc queries) | |||
Linear Mode
