Hello all,

I'm using an excel sheet for a fantasy baseball draft. I have 3 lists where
players are listed on the same sheet. Each list is a different category.
Because the info is pasted in from 3 different sources, the names show up
slightly differently. For example:

Alexei Ramirez
Ramirez, Alexei 2B
Ramirez, Alexei

Is there a way to delete the contents of these 3 cells after doing a
control-F find all based on just the term Alexei? So, I want to use a common
name in each cell to find all 3 and then delete the contents.

TIA