Hi all, I've searched with little luck, I'm new to excel and can't edit these VBA's by myself enough to solve.
I want to scan Column A for characters or strings in column B and replace them with Column C, in this case a blank.
May I have a VBA macro to scan list A2:A5000, replacing any value or string found in column B with a blank, or if I decide to rename, resource the value from Column C?
Extra description
So A2 is Keep-delete #234 and i'd like it to just say Keep
A3 is ImpactSowKeep#1111 and i'd like it just say Keep
This is to replace writing out 50 SUBSTITUTE(SUBSTITUTE, and be modular for the future! Thanks!
I want to scan Column A for characters or strings in column B and replace them with Column C, in this case a blank.
May I have a VBA macro to scan list A2:A5000, replacing any value or string found in column B with a blank, or if I decide to rename, resource the value from Column C?
Extra description
So A2 is Keep-delete #234 and i'd like it to just say Keep
A3 is ImpactSowKeep#1111 and i'd like it just say Keep
This is to replace writing out 50 SUBSTITUTE(SUBSTITUTE, and be modular for the future! Thanks!
Last edited: