Results 1 to 9 of 9

Editing Social Security Numbers from current numbers to some with XXXX inserted automatica

Threaded View

davidingilbert Editing Social Security... 11-01-2012, 01:58 PM
alansidman Re: Editing Social Security... 11-01-2012, 02:04 PM
davidingilbert Re: Editing Social Security... 11-01-2012, 02:13 PM
davidingilbert Re: Editing Social Security... 11-01-2012, 03:27 PM
FDibbins Re: Editing Social Security... 11-01-2012, 03:31 PM
davidingilbert Re: Editing Social Security... 11-01-2012, 03:35 PM
alansidman Re: Editing Social Security... 11-01-2012, 04:09 PM
davidingilbert Re: Editing Social Security... 11-01-2012, 05:35 PM
alansidman Re: Editing Social Security... 11-01-2012, 07:49 PM
  1. #1
    Forum Contributor
    Join Date
    06-03-2009
    Location
    Phoenix, Az
    MS-Off Ver
    MS Office 365
    Posts
    145

    Editing Social Security Numbers from current numbers to some with XXXX inserted automatica

    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
    Last edited by davidingilbert; 11-01-2012 at 02:02 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1