Dear reader,
I want Excel to search column J accross 20 records. In all 20 J-cells there are different text strings. I want Excel to print the text string it finds in each of the J-cells into column K where I put the formula - if my formula's condition is met.
My formula is =IF(LEFT(J17,3)="AR ";J17;"")
This formula should look at the 3 leftmost characters in cell J17 and return the text string it finds in J17 - if it is true - into K17. If it is false, it should just return no visible content. However, this formula produces an error message. I just cannot find the reason for this malfunction.
Please help!
Bookmarks