I have some cells custom formatted as 000-00-0000 for social security
numbers. On other sheets, I only need the last four of the SSNs. I
tried to use find *- and replace with " " but it did not work. Is
there a way to do this without using a macro? Also, is there a way to
do this using the special SSN format in Excel 2007? It will work if I
manually input the SSN with the dashes and not custom formatting.

hi
you could bring the last 4 over with a formula.

=right(sheet1!A2,4)

look up the right, left and mid functions in xl help.

regards
FSt1

"SGT Buckeye" wrote:

I have some cells custom formatted as 000-00-0000 for social security
numbers. On other sheets, I only need the last four of the SSNs. I
tried to use find *- and replace with " " but it did not work. Is
there a way to do this without using a macro? Also, is there a way to
do this using the special SSN format in Excel 2007? It will work if I
manually input the SSN with the dashes and not custom formatting.