Thread: split prefix and suffix
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RayNDM83 RayNDM83 is offline
external usenet poster
  
Posts: 9
Default split prefix and suffix
C22K001
C15K015A
FA28K005A

Hi,
Could someone help me to split the cell and drop the prefixes C and FA as
well as the suffix A? What will be left will read 22K-001, 15K-015 or 28K-005.
Thanks for the help.
Ray
Reply With QuoteReply With Quote