how to get middle value from a string in excel or find value between two character or word?

IF you want to get middle value from a string in excel or find value between two character or word?
Let ...
If the value is  32000=1=10.44|32000=12=7.64|3200 and you want to get "10.44" value
It is little bit long way but you can get exact result...

First you should use

=MID(A1,2,2)    This formula it will return you a string like

=MID(A1,9,10) where 9 is the value where you want to start to select value and 10 is that how much character you want to put
It will return something like this "10.44|3200"

Now you  in other colon use this code for last result

=LEFT(B1,FIND("|",B1,1)-1)

Use this formula it will return you your value which you want to get like: 10.44