This seems to work:

=MID(A1,FIND("|",A1)+1,FIND("|",MID(A1,FIND("|",A1 )+1,99))-1)

Hopefully someone else will come up with a shorter version.

Regards,
Fred.

"Tony S." wrote in message
...
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!