| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a formula to remove dashes?
I'm new to Excel. I have a huge inventory spreadsheet where I need to change
a column to reflect the following. "P01-02-C-1" should become "P102C1" (remove 0 and dashes) "V1-25-F-2E" should become "125F2E" (remove V and dashes) HELP!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove dashes from phone numbers in a spreadsheet | Excel Worksheet Functions | |||
| Why do the preceding zeros disappear when I remove dashes? | Excel Discussion (Misc queries) | |||
| how to remove dashes | Excel Worksheet Functions | |||
| Remove Dashes from Social Security Numbers | Excel Worksheet Functions | |||
| remove the ( ) & dashes from column of phone # | Excel Worksheet Functions | |||
Threaded Mode
