If Cell is like

**stevetothink** · 09-13-2013, 08:48 AM

Is it possible to write a formula that identifies cell data in the format of a social security number? Something like this.

=if(A1 like "???-??-????", A1, B1)

The goal is to tell Excel to return A1 if A1 is formatted like a social security number. Otherwise, return B1.

Thanks,
Steve

**XOR LX** · 09-13-2013, 09:00 AM

Hi,

=IF(AND(LEN(A1=11),SUMPRODUCT(--(ISNUMBER(--MID(A1,{1,5,8},{3,2,4}))))+SUMPRODUCT(--(MID(A1,{4,7},1)="-"))=5),A1,B1)

Regards

**alansidman** · 09-13-2013, 09:11 AM

Here is a short tutorial on how to create an if statement based upon the format of a cell. Regretfully, Excel does not appear to have a format code for the special format Social Security Numbers.

http://office.microsoft.com/en-us/ex...010062392.aspx

If Cell is like

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

If Cell is like

Re: If Cell is like

Re: If Cell is like

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] When one cell equals value of another cell, then third cell displays text of fourth cell?

How to create/run "cell A equals Cell B put Cell C info in Cell D

copy a cell multiple times depending on cell value starting on a specific cell

cell 1 passing data to cell 2 then cell 1 reverts back to 0 while cell 2 maintains sum

Change Cell Font Color if Cell Contains Formula Referencing Another Cell

Bookmarks

Bookmarks

Posting Permissions