I'm trying to search through a list of company names which include universities and states. I want to eliminate any instance of the word "university" or "state of", regardless of where it occurs in the cell. How would I go about doing that?
Printable View
I'm trying to search through a list of company names which include universities and states. I want to eliminate any instance of the word "university" or "state of", regardless of where it occurs in the cell. How would I go about doing that?
Use the Find method (shown in my Excel Tips and Tricks link) using the argument LookAt:=xlPart to do the search, then just use Replace or Instr to rewrite teh string. Then use FindNext (see VBA Help) to keep searching...
zaza