Finding a name with partial description and deleting all occurrenc

P

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
 
A

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top