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
Thanks for answer, because sometimes amount of characters of substring is different in my data. Sometimes 16, 17 and sometimes 18 characters. That's why I want to use formula which extract text before and after special characters like "_", "," and sometimes " G..."
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
- That's great. I do not have information about "Iferror" function. It is working in this formula {=MID(LEFT(A2;IFERROR(FIND(",";A2);FIND("Y";A2))-1);FIND("_";A2)+7;18)}
Thanks.
