Thread: Extract between Pipe symbol
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tony S.[_2_] Tony S.[_2_] is offline
external usenet poster
  
Posts: 60
Default Extract between Pipe symbol
Can someone please tell me if it is possible to write a formula that would
extract all the text that exists between the vertical bar symbol "|".

Example in the following Cell A1 contains:
W213FR|BADC12GW34-14|SPACER, DEG

I want to extract only "BADC12GW34-14" and put it in another cell, say B1.
Thanks!
Reply With QuoteReply With Quote