omitting/deleting "-"'s from numbers w/ formula

[Eric D]

I have a group of numbers that look like this ###-##-####g09. I have been
able to omit the "g09" at the end but i need the "-"'s omitted as well. Can
this be done with a formula or do i just need to use find/replace?

Thanks

 

[Gary''s Student]

=SUBSTITUTE(LEFT(A1,11),"-","")
so
123-45-6789g09
will output
123456789

 

[Eric D]

Thanks Gary, that works great!