Getting a value from a string

[djfatboyfats]

Good afternoon,

I need to get the the value (3197.01) from this string below, can anyone help?
The formant will always be the same so I need to pull out anything after Value: and Before Authorisation Code

Please Login or Register  to view this content.

Thanks in advance

[FDibbins]

Try this...
=--MID(A1,7,9)

[djfatboyfats]

Sorry that did'nt work sorry

[misrasomendra]

Considering text in J15 try:

=MID(J15,8,FIND("Authorisation",J15)-FIND(": ",J15)-2)

[djfatboyfats]

Gave me the results of "ayment: 1"

[alansidman]

Assume this is in cell A1

Please Login or Register  to view this content.

=MID(A1,FIND(":",A1)+1+1,FIND(" ",A1,FIND(":",A1)+2)-FIND(":",A1)-1)

[FDibbins]

Sorry that did'nt work sorry

what didnt work? what was the outcome?

maybe this then
=--MID(B3,FIND("@",SUBSTITUTE(A1," ","@",1),1)+1,(FIND("#",SUBSTITUTE(A1," ","#",2),1)-FIND("@",SUBSTITUTE(A1," ","@",1),1)-1))

[misrasomendra]

If this is a continuous text in one cell try:

=MID(J14,FIND("Value: ",J14)+7,FIND("Authorisation",J14)-FIND("Value: ",J14)-7)

[djfatboyfats]

alandsidman Your code worked however this is whats in cell A1

Please Login or Register  to view this content.

So the formula is pulling the 123456 number instead

[djfatboyfats]

misrasomendra Your latest code worked fine. Thanks everyone for your input

[misrasomendra]

Thanks for the feedback.