VBA Question - Remove keywords from cell text
I have a need to reduce the amount of text in a range of cells. There are
certain keywords that are not necessay in the cells that if removed the text
length would be acceptable.
How do I go about removing keywords from cell text with VBA? This would
need to run in column G of my worksheet.
Here is an example: (keywords are "Q Line" & "120 VAC")
Befo
Q Line THQB 120 VAC 1 pole 20A
After:
THQB 1 pole 20A
Thanks in advance!
|