Hello all.
I am attempting to come up with a formula or something that will take social security numbers downloaded from another system in this format of 123-45-6789(Where I cannot fix the format) and automatically change them this format:
xxx-xx-6789
I need to do this for an entire column of numbers for 125 prospective customers.
Any help would be appreciated.
Sorry if this has been posted already, but could not find it.
Thanks.
Dave
If the data is in Col A starting in A1,
In B1
="XXX-XX-"&RIGHT(A1,4)
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Deja vu LOL
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks