| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a formula to remove dashes?
highlight the column header (ie C)editreplace - blank
-- Don Guillett Microsoft MVP Excel SalesAid Software "jackierae17" wrote in message ... 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!! |
| Reply |
| 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 | |||
![Don Guillett[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
