Sir Babydum GBE
02-22-2008, 04:17 AM
Hi
This is a formula one more than VBA...
In the attached, I need to try and get Babydum's results to include the various ways Babydum appears in the list. In reality, if there were only two possibilities it would be easy, but on a real list there are many names and some have three or four suffixes - so I tried using Left(len but I couldn't get it to work.
Any ideas?
Cheers
BD
This is a formula one more than VBA...
In the attached, I need to try and get Babydum's results to include the various ways Babydum appears in the list. In reality, if there were only two possibilities it would be easy, but on a real list there are many names and some have three or four suffixes - so I tried using Left(len but I couldn't get it to work.
Any ideas?
Cheers
BD