Thread: How to remove characters in a cell that precede a specific hyphen
View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.misc
Suraj Noorsai Suraj Noorsai is offline
external usenet poster
  
Posts: 2
Default Hyphens problem
a1 = ABC-12345-12345

ANSWER IS

=mid(a1,54,5) and
answer = 12345
Reply With QuoteReply With Quote