I need to make 111-11-1111 into 111111111

I have a spreadsheet that was sent to me that has social security #'s in a
111-11-1111 format. I need to make it a 111111111 format. I just just
wondering what formula I could use to get rid of the hyphens.

No formula necessary. Select the column, hit Ctrl+H, enter a hyphen in the
find, and don't put anything in the replace with; replace all.
************
Anne Troy
www.OfficeArticles.com

"Crawdaddy" <[email protected]> wrote in message
news:[email protected]...
>I have a spreadsheet that was sent to me that has social security #'s in a
> 111-11-1111 format. I need to make it a 111111111 format. I just just
> wondering what formula I could use to get rid of the hyphens.

=SUBSTITUTE(A1,"-","")
or just use Edit > Replace > Replace What > - > Replace with > Nothing >
Replace All,
Regards,
Alan.
"Crawdaddy" <[email protected]> wrote in message
news:[email protected]...
>I have a spreadsheet that was sent to me that has social security #'s in a
> 111-11-1111 format. I need to make it a 111111111 format. I just just
> wondering what formula I could use to get rid of the hyphens.