| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to remove dashes in Social Security number
Each month I receive an excel spreadsheet and one of the columns has social
security numbers with the dashes. I have to import it into Access without the dashes, how can I remove the dashes from the social security numbers in Excel - without doing it by hand ? Is there a way to use format cells to clear the dashes ? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove dashs from social security numbers | Excel Discussion (Misc queries) | |||
| Remove the hypens from a social security number | Excel Discussion (Misc queries) | |||
| Remove Dashes from Social Security Numbers | Excel Worksheet Functions | |||
| How do I format a social security number to have no dashes? | Excel Discussion (Misc queries) | |||
| Social Security Number | Excel Discussion (Misc queries) | |||
Threaded Mode
