Finding a name with partial description and deleting all occurrenc

[pm]

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

 

[Alan]

You would need to use VB code to do that, but one way to extract 'Alexei' or
'Ramirez' from each cell, with the list in column A, enter 'Alexei' or
'Ramirez' into F1 and this formula into B1 and drag down to the end of the
list,

=MID(A1,SEARCH($F$1,A1),LEN($F$1))

Regards,
Alan.