Formula needed

[bbbenaway]

In MS Excell, am needing a formula whereas I can enter a complete social security number in one cell, and it would then propogate to other areas (cells)of the form, but only showing the last for digits. Example: 555-55-5555 to ******5555. I would need this to propogate to several different cells throughout the form.

 

[GlennUK]

Something like:

=REPT("*",LEN($A$1)-4)&RIGHT($A$1,4)

in those cells, replacing $A$1 with the cell ref of where the SS number is.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[smah]

Or as long as the original SS# is entered in the ###-##-#### format:

=REPLACE(A1,1,6,"***-**")

where A1 is the cell containg the SS#
(for the sake of this conversation, we're ignoring the security related issues)