Forum Discussion
Solved
How to solve this "VALUE" error in excel with just one formula
I want to extract this part => "1.3215809385571036" from following text and I use this formula {=MID(LEFT(A2;FIND(",";A2)-1);FIND("_";A2)+7;18)} for this. "4_1100_ 1.3215809385571036, X-Ray checking...
turan_aghayev Then use this part to either find a comma or " G".
IFERROR(FIND(",";A2);FIND(" G";A2))-1
rather than just FIND(",";A2)-1
turan_aghayev You seem to want to extract the 18 characters, starting at the ninth. Why not just use:
=MID(A2;9;18)
Alternatively, if the first underscore "_" may be in different places sometimes, use:
=MID(A2;FIND("_";A2)+7;18)