| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Remove Dashes from Social Security Numbers
How do I remove the dashes from SSN's on a spread sheet? They are NOT setup
as '111-11-1111 I also have a lot of SSN's that start with 00X-XX-XXXX and I still need the 0's (zeroes) to show. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Remove Dashes from Social Security Numbers
=SUBSTITUTE(A1,"-","")
and format as 0000000000 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "catrose" wrote in message ... How do I remove the dashes from SSN's on a spread sheet? They are NOT setup as '111-11-1111 I also have a lot of SSN's that start with 00X-XX-XXXX and I still need the 0's (zeroes) to show. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Remove Dashes from Social Security Numbers
how about using SUBSTITUTE
-- Don Guillett SalesAid Software "catrose" wrote in message ... How do I remove the dashes from SSN's on a spread sheet? They are NOT setup as '111-11-1111 I also have a lot of SSN's that start with 00X-XX-XXXX and I still need the 0's (zeroes) to show. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Remove Dashes from Social Security Numbers
Edit | Replace | Find What:- | Replace With: "leave it blank" | click Replace
All Format | Cells | Number tab | Custom | Enter 000000000 --------------- mama no teeth "catrose" wrote: How do I remove the dashes from SSN's on a spread sheet? They are NOT setup as '111-11-1111 I also have a lot of SSN's that start with 00X-XX-XXXX and I still need the 0's (zeroes) o show. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Remove Dashes from Social Security Numbers
That worked perfectly. Thank you!!!!
"Nobody" wrote: Edit | Replace | Find What:- | Replace With: "leave it blank" | click Replace All Format | Cells | Number tab | Custom | Enter 000000000 --------------- mama no teeth "catrose" wrote: How do I remove the dashes from SSN's on a spread sheet? They are NOT setup as '111-11-1111 I also have a lot of SSN's that start with 00X-XX-XXXX and I still need the 0's (zeroes) o show. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Social Security Payment Dates | Excel Discussion (Misc queries) | |||
| Convert phone numbers with dashes in them to just numbers | Excel Discussion (Misc queries) | |||
| format social security number | Excel Worksheet Functions | |||
| Social Security Number | Excel Discussion (Misc queries) | |||
| how do Ii remove the grey page numbers in a work sheet | Excel Discussion (Misc queries) | |||
Linear Mode
