Home |
Search |
Today's Posts |
#1
|
|||
|
|||
social security numbers
How do I change social security numbers so that all the dashes are removed?
thank you for your help in advance. Jean |
#2
|
|||
|
|||
Have a look in HELP for SUBSTITUTE
-- Don Guillett SalesAid Software "Jean" wrote in message ... How do I change social security numbers so that all the dashes are removed? thank you for your help in advance. Jean |
#3
|
|||
|
|||
Thank you, I did look there first but cannot understand how to convert the
format from dashes to no dashes, even after looking at that section of the help. I have 800 records to convert and do not want to have to go in and delete all the dashes if I can do it an easier way! "Don Guillett" wrote: Have a look in HELP for SUBSTITUTE -- Don Guillett SalesAid Software "Jean" wrote in message ... How do I change social security numbers so that all the dashes are removed? thank you for your help in advance. Jean |
#4
|
|||
|
|||
Maybe just select the range with the SSNs with dashes and
Edit|replace what: - (hypen) with: (leave blank) replace all Then format it as a SSN (format|cells|number Tab|special|SSN) as a formula that returns text: =substitute(a1,"-","") or as a formula that returns a number: =--substitute(a1,"-","") Jean wrote: Thank you, I did look there first but cannot understand how to convert the format from dashes to no dashes, even after looking at that section of the help. I have 800 records to convert and do not want to have to go in and delete all the dashes if I can do it an easier way! "Don Guillett" wrote: Have a look in HELP for SUBSTITUTE -- Don Guillett SalesAid Software "Jean" wrote in message ... How do I change social security numbers so that all the dashes are removed? thank you for your help in advance. Jean -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to sort names and social security numbers a to z | Excel Worksheet Functions | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
How can I compare 2 sets of Social Security #'s and Identify dupes | Excel Discussion (Misc queries) | |||
(social security number) 000-00-0000 to 000000000 | Excel Discussion (Misc queries) | |||
social security sorting | Excel Worksheet Functions |