Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagHow can I add auto row number when the group changes the row number restart again ? How can I add auto row number ("S\S" column in excel file) when the group changes the row number restart again ? I want to give a conditional formatting to the "anniversary date" column I want to give conditional formatting to the "Anniversary Date" column which the cell should be colored less than 45 days before that date SolvedHow can I calculate anniversary date (10, 20, 30, 40, 50, and etc.) ? Re: How to solve this "VALUE" error in excel with just one formulaThat'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.Re: How to solve this "VALUE" error in excel with just one formula 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..." 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, Kino checking, GPS avto (kadr)" But sometimes my text is looking like this and formula return "VALUE" error because "Find" function can not find "," and return error. "1_1100_ 1.2152157818772644 Green gas. fekfmf eujffmmef. GPS chechking." How to solve this problem? How to write this formula for ....FIND(",";A2) and also FIND(" G";A2) with just one formuLLa ? Solved
