ssn

  1. R

    Convert SSN in one column to text in the adjacent column

    I have a table with around 10,000 records. The records are medical claims, where an individual claimant may have many rows of different types of claims. The individuals are identified by their Social Security Number (ClaimantID). I've created a column, Claimant Alias, where I use the =RIGHT()...
  2. R

    Convert SSN in one column to text in the adjacent column

    I have a table with around 10,000 records. The records are medical claims, where an individual claimant may have many rows of different types of claims. The individuals are identified by their Social Security Number (ClaimantID). I've created a column, Claimant Alias, where I use the =RIGHT()...
  3. R

    Ssn numbers

    Hi all so i have a problem with social security numbers that start with 0 (zero). My cell is formated special and social s number ex. 015-60-1158. When i use the find button it will not find ssn starting with 0, to find the ssn i'm looking for i have to key in without the zero. Is there a way...
  4. R

    Find button

    Hi all I have a sheet with soc. S numbers and start with 0. How do format so excel will find the ssn starting with 0?
  5. T

    VB help on work project

    Hello Everyone, I'll let you know I'm in accounting. I don't know a significant amount about VB but i've done a few projects that have at least given me a bit to work with. I need help with 1 part of my current project. Every Quarter I receive dozens of spreadsheets that I need to analyze...
  6. T

    Persistent formatting issue (custom, special)

    Hello all, and thanks for reading. I need to import a new spreadsheet (or simply its data) into an ongoing Excel project that I've been working on. The only identifying data on this new document are social security numbers (SSNs). They are hard-coded with hyphens, which I text-to-columns'ed...
  7. D

    SSN formatting

    I am having trouble formatting a column of SSN. I need them to be in the 123-45-6789 format. I have tried special formatting, custom formatting, and neither are working. I am using office 2007 but think the file sent to me is excel 2003 if this makes a difference. Any help or advice is...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top