Remove Social Security #'s From a Text Cell

[Requius]

In my roll I generate allot of reporting with information submitted by others which often times includes text that I need to copy/paste into an excel text cell. We get allot of these that have full Social Security #'s in them and I'd like to create a formal (preferably not a VBA) to search the cell and indicate if a SS# (with or without dashes) is included. That way I can simply review the note and pull the SS# from the text.

I've seen many great responses to add dashes, remove dashes, or even obscure part of the SS# from the cell but nothing that does a simple search of the cell (let's say A1) and in Cell A2 says "SS# included" or similar.

This is my first post, ever, so please be gentle on me

 

[steve the fish]

It would be useful in this instance to give examples of what you have and what you would like to extract.