Forum Discussion
How to solve this "VALUE" error in excel with just one formula
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)
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.
