I am looking to create a VBA to find a select word in a text string in col F (such as; "A/L", or "AREA", or "AL") and if found add in col 3 the word "AREA" I tried finding others in this website and review their solutions but none appear to be working for me. This is a sample of what I am looking at. Description is column F, I used bold font to show you this report doesn't bold anything. If I can have the word "AREA" in column E then I can filter the report quickly. Can the experts here help me?
AREA Requests | Description |
LGS RSC 87 | |
AL request | |
A/L RSC 87 | |
list of outages RSC 83 | |
89-Raymond-AL inquiry | |
empty building | |
A/L CONTRACT RSC 86 | |
IGS Demand Inquiry RSC 85 | |
Adding A/L Contract | |
RATE REVIEW | |
Review Deposit | |
MANUAL RATE REVIEW REQUEST | |
Rate Change | |
RATE CHANGE |