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

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
--
Eric

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

=SUBSTITUTE(LEFT(A1,11),"-","")
so
123-45-6789g09
will output
123456789
--
Gary''s Student - gsnu200826

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

Thanks Gary, that works great!
--
Eric


"Gary''s Student" wrote:

=SUBSTITUTE(LEFT(A1,11),"-","")
so
123-45-6789g09
will output
123456789
--
Gary''s Student - gsnu200826