| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace first part of SS# with x's (XXXX-XX-9999)
I am trying to write a code that will take the full social securit
number 9999-99-9999 and turn it into the following: XXXX-XX-9999, th first numbers can be deleted, with only the last four remaining. I kno this is really simple for you pros out there, but I cannot do it! Please help me! -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format a number (i.e. 1111111111111111) to show XXXX-XXXX-1111-11 | Excel Discussion (Misc queries) | |||
| replace last four of ssn with xxxx | Excel Discussion (Misc queries) | |||
| adding a ' ie 'xxxx instead of xxxx | Excel Worksheet Functions | |||
| change dots to dashes in an account format (xx.xxxx.xxxx) to xx-xx | Excel Discussion (Misc queries) | |||
| within a macro how can I suppress the warning pop "A file named xxxx.xls already exists in this location. Do you want to replace it?" | Excel Programming | |||
Threaded Mode
