Forum Discussion
jojomartin845
May 01, 2026Occasional Reader
Put a specific word in a cell based on the word in another cell
Hey everyone, I need help automating the categorisation of my bank statement in excel. I do not have microsoft 365. I want excel to look for specific words from my transactions eg Woolworths or McD...
SnowMan55
May 02, 2026Bronze Contributor
I have fleshed out some possible solutions in this workbook on Microsoft OneDrive: 2026-05-02 JJM categorize expenditures by keywords.xlsx The _Info worksheet contains explanations and references.