=IF(ISERROR(FIND("Total:";A1));"";VALUE(MID(A1;FIND("Total:";A1)+6;LEN(A1))))
Well I need to have the exact data entered next to "Total:" returned in Cell B1 whether it is numeric or alphanumeric or numeric with symbol (dash or hyphen to be more specific) in between like "4-19". I hope this is possible.
Expenses breakdown Expense 1: 10 Expense 2: 15 Total: 25 Limit: 20 Remaining: -5 Result: Over the Limit
=MID(A1;SEARCH("Total:";A1)+6;SEARCH(CHR(10);A1;SEARCH("Total:";A1)+6)-SEARCH("Total:";A1)-6)
=MID(A1;SEARCH("Total:";A1)+6;SEARCH(CODE(10);A1;SEARCH("Total:";A1)+6)-SEARCH("Total:";A1)-6)
=IF(ISERROR(FIND("Total:";A1));"";VALUE(MID(A1;FIND("Total:";A1)+6;LEN(A1))))
=IF(ISERROR(FIND("Total:";A1));"";MID(A1;SEARCH("Total:";A1)+6;SEARCH(CODE(10);A1;SEARCH("Total:";A1)+6)-SEARCH("Total:";A1)-6))
jhonpaul72 wrote:I want to have the Cell A2 blank if the "Total:" string is not present/detected, instead of #VALUE!.
Users browsing this forum: No registered users and 11 guests