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
Bookmarks