If the number that you want to extract always begins after second instance
of "|" and ends just before "^" then use the following: -
=--(MID(A1,FIND("xx",SUBSTITUTE(A1,"|","xx",2))+1,FIN D("^",A1)-(FIND("xx",SUBSTITUTE(A1,"|","xx",2))+1)))

If the number that you want to extract always begins after second instance
of "|" and ends just before "^" then use the following: -

"smb2000user100" wrote in message
...

I can not find a solution for it. Please help me. Thank you!
--
George