ExcelBanter - (social security number) 000-00-0000 to 000000000

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - (social security number) 000-00-0000 to 000000000 (https://www.excelbanter.com/excel-discussion-misc-queries/10549-social-security-number-000-00-0000-000000000-a.html)

Cucuaq

(social security number) 000-00-0000 to 000000000

I have a list of 1300 SSN's to change from 000-00-0000 to 000000000. Is
there a way I can just change them all at once instead of one by one?

Bob Phillips

Select all the cells and so a Find/Replace (Ctrl-H) on the hyphen character

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Cucuaq" wrote in message
...
I have a list of 1300 SSN's to change from 000-00-0000 to 000000000. Is
there a way I can just change them all at once instead of one by one?

All times are GMT +1. The time now is 03:15 AM.