I’m trying to write a formula that will search for certain words contained in the cells of Column A and then return those words in column B. The contents of each cell will contain more information than the key word being searched for.
The aim will be to import transaction descriptions into Column A and then to search the descriptions for key words which will be used as transaction categories. So for example, Column A may contain…
A
1 1234 petrol
2 4565 joe blogs div
3 Interest Charge
I want to search A1, A2, A3 etc for the words “petrol”, “div” and “Charge” and then return “petrol”, “div” or “charge” into the corresponding row in column B. So that B1 shows “Petrol”, B2 shows “Div”, B3 shows “Charge”. Any help would be much appreciated. I don’t think you can use wild cards with nested IFs so I’m a bit stuck.
Bookmarks