D
Don
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.
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.