Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding a name with partial description and deleting all occurrenc
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding a name with partial description and deleting all occurrenc
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. "pm" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FINDING PARTIAL ENTRIES IN A CELL/ARRAY | Excel Discussion (Misc queries) | |||
Deleting partial information from all cells in a column | Excel Worksheet Functions | |||
Finding and Deleting | New Users to Excel | |||
Finding and Deleting duplicates in a column | Excel Worksheet Functions | |||
Finding Partial Text in a Cell | Excel Worksheet Functions |