Pull text between 2 characters in cell

[krystalhaze]

Hi All,
I'm sure someone has asked a similar question before, but tbh, I really wanted to get a direct answer to my specific question, so I don't have to spend time figuring out how to retrofit another answer. :P
I would like to pull out the contents from the middle of a cell between two vertical separators (|) - the length of the contents in the cells will vary.
Examples:
Serv1|Tab1|Col1 - want "Tab1"
Server1|Table1|Column1 - want "Table1"
TIA!

 

[jtakw]

Hi,

One way:

Book1
	A	B
1	Serv1|Tab1|Col1	Tab1
2	Server1|Table1|Column1	Table1
Sheet585

Cell Formulas
Range	Formula
B1	=TRIM(MID(SUBSTITUTE(A1,"|",REPT(" ",99)),99,99))

 

[jtakw]

You're welcome, thanks for the feedback.