Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search group of cells for several sets of character strings
I need to find several diff spellings of someone's name in a large group of
cells per row. In the large group of cells there will be cases where a single cell may contain several names in that cells character string (A1 = "Billy Smith Joe Jones Ralph") and I need to pick any of the different source spellings out of a cell containing many characters/names. The different spellings could be set up in a few separate cells: "Bill Smith", "Billy Smith", "William Smith" etc Then a much larger array of cells (xx rows by yy columns) will hold many, many names in some cases several per cell that need to be searched thru. I just need to test per row. So if a row has any of the source names then give me a one or the location of the start of that hit. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 sets of =if strings in excel 2007 | Excel Discussion (Misc queries) | |||
Date Formating and building character strings | Excel Discussion (Misc queries) | |||
testing for character strings within a cell | Excel Worksheet Functions | |||
Finding 13 character codes in text strings | Excel Worksheet Functions | |||
Fast way to search many cells by column for text strings | Excel Discussion (Misc queries) |