Thread: omitting/deleting "-"'s from numbers w/ formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default omitting/deleting "-"'s from numbers w/ formula
=SUBSTITUTE(LEFT(A1,11),"-","")
so
123-45-6789g09
will output
123456789
--
Gary''s Student - gsnu200826
Reply With QuoteReply With Quote