Really hard challenge !! How to standardize Capital letters on names

Hello,

I'm looking to modify an unconsistent series of names (included compound names and particles) in order to unify all words.

Please look at my file its clearer with an example.

I've been looking for days now how to work out that issue, searching for help on different forums without success till now.

I hope you can Help me

Thanks a lot

solution 1 =PROPER(A4)
solution 2 =PROPER(LEFT(A4,FIND(" ",A4)))&UPPER((MID(A4,FIND(" ",A4),500)))

Try this formula:

Formula:

Please Login or Register  to view this content.

You will probably have to change the commas to semicolons. I've shown this in column F of the attached workbook.

Hope this helps.

Pete