wrote...
....
I have a ton of these cells and they're all different, but I only
need the word left of the first "|" mark and right of the second
"|" mark.
....

Looks like you mean between the 1st and 2nd |s. Try

=REPLACE(LEFT(A1,FIND("|",A1,FIND("|",A1)+1)-1),1,FIND("|",A1),"")