| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove the hypens from a social security number
I just want to display the numbers without hypens, is there a formula?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove the hypens from a social security number
Try
=left(A1,3)&mid(A1,5,2)&right(A1,4) where the number is in cell A1 Judith -- Hope this helps "Geish" wrote: I just want to display the numbers without hypens, is there a formula? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove the hypens from a social security number
If they are numbers formatted as SSN then just use
000000000 custom format, if they are text then just press ctrl + h and replace - with nothing -- Regards, Peo Sjoblom "Geish" wrote in message ... I just want to display the numbers without hypens, is there a formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Social Security Number formatting | Excel Discussion (Misc queries) | |||
| Remove Dashes from Social Security Numbers | Excel Worksheet Functions | |||
| format social security number | Excel Worksheet Functions | |||
| Social Security Number | Excel Discussion (Misc queries) | |||
| Social Security Number format | Excel Worksheet Functions | |||
Hybrid Mode
