Hi all,

I've gone through various threads on the forum regarding the topic, but haven't found any that covers what I'm looking for.

I have reports that I pull weekly, that contain a column with ~40 different names (ex: golf balls, golf clubs, bats, gloves, baseballs).

I want to do a Find & Replace on the entire column range. To clarify:

If rows in B:B = 'Golf Balls' then replace with 'Golf'
If rows in B:B = 'Golf Clubs' then replace with 'Golf'
If rows in B:B = 'Bats' then replace with 'Baseball'
If rows in B:B = 'Gloves' then replace with 'Baseball'
etc etc

There is no part in the string that identifies what the replacement value will be... so it will need to match the entire cell contents, and then rename it based on that.

Thanks.

D