S
SGT Buckeye
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.
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.