Check for small caps after the first space.

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

Please Login or Register  to view this content.

English

Please Login or Register  to view this content.

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

Please post a file (not image) , showing some expected results (as per your post).

Originally Posted by JohnTopley

Please post a file (not image) , showing some expected results (as per your post).

Thought I attached it the first time.