Thread: omitting/deleting "-"'s from numbers w/ formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Eric D Eric D is offline
external usenet poster
  
Posts: 50
Default 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
Reply With QuoteReply With Quote