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
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