On Wed, 9 Jul 2008 06:25:00 -0700, bollard
wrote:

Hi Ron

We've put the formulae you gave into place and have since identfied one
problem. It's OK at identifying all the initials that occur between title and
surname, but it can't cope with people whose surname consists of 2 words or
more, that are not hyphenated, e.g.:

van Bommel
le Clerc
van den Bosch
de la Rue

Is there any way we can tweak the formula for the initials to recognise
strings as opposed to indiviudal initials? When it finds, for example, van
Bommel, it treats that surname as if 1 word.

Hope that all makes sense!

Thanks.

Keith

With this level of complexity, I would use VBA functions. But we would need to
know the entire range of possible data in order to do this.

For example, if it is the case that the format is always:

<title <0-n initials <1-n strings of at least 2 letters

this can be easily done. Let me know if this is the case, or if there is more
variation.
--ron