Hello,

I'm using the formula show below, and a conditional formatting to color all cells start with a small capp.
Therefore in a list of 8000+ records, i can quickly see which name needs to be altered.

Dutch 
=GELIJK(LINKS(H2;1);KLEINE.LETTERS(LINKS(H2;1)))
English 
=EXACT(left(H2,1),LOWER(left(H2,1)))
Now i would like to do the same with the first letter after the first space.

See the enclosed example for a working function.

The function i'm looking for looks a lot like the "PROPER' function, but that one messes up the inserts between names (in dutch: van, van de, van der, el)
"Kees van der Poel" will be shown as "Kees Van Der Poel" and in dutch this is grammatically incorrect.

The idea is to use the same function but the with the FIND function embedded, anyone an idea?

Best Regards

ABBOV