wilg
09-22-2011, 06:34 AM
Hi, I have a lenghty list of first names in column A and last names in column C. In column A I have the formula
=TRIM(B1&" "&LEFT(C1,2))
This gives me as example
John Do
I need this to differientiate the person if there is more than one John. What I want is to...
1. Only use the formula if lookup finds more than one John as eg..
2. If it finds more than one John D, then continue with the next character to differentiat between them. EG. John Doe, John Doea may need 4 characters to tell the diff.
All help is appreciated thanks...
=TRIM(B1&" "&LEFT(C1,2))
This gives me as example
John Do
I need this to differientiate the person if there is more than one John. What I want is to...
1. Only use the formula if lookup finds more than one John as eg..
2. If it finds more than one John D, then continue with the next character to differentiat between them. EG. John Doe, John Doea may need 4 characters to tell the diff.
All help is appreciated thanks...