| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove hyphens from SSN
Please help...
Is there a way to remove hyphen from SSN without stripping out the leading zeros? I used the replace function under the Edit menu -- Find "-" and Replace with "". It worked on some SSNs but didn't on the SSNs with leading zeros. 001-23-4567 ==1234567 (expected result = 001234567) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove hyphens in text | Excel Worksheet Functions | |||
| How do I remove hyphens from a product UPC? | Excel Worksheet Functions | |||
| How can I remove all hyphens in a column without retyping? | Excel Discussion (Misc queries) | |||
| how do i remove hyphens from between numbers | Excel Worksheet Functions | |||
| How do i remove the hyphens between numbers without having to edi | Excel Discussion (Misc queries) | |||
Threaded Mode
