Thread: How to remove characters in a cell that precede a specific hyphen
View Single Post
  #19   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Hyphens problem
If that is the answer, then I am confused about what the question is? :-)
--
David Biddulph

<Suraj Noorsai wrote in message
...
a1 = ABC-12345-12345

ANSWER IS

=mid(a1,54,5) and
answer = 12345


Reply With QuoteReply With Quote