Grammar solver/name combiner

hello everyone *~_^
This is the issue i have, and from what i know already, i dont think its going to be easy to solve, but thats why im here, because i dont know.

So the issue is, we have a excel sheet that gathers names, (first and last) and we dont have any issues combining them, however, what we want to do is create a formula, or a line of code that sees all the individual letters in the names and corrects them grammatically, IE (first letters in the name uppercase and the rest of the letters in the names lowercase) unless there is a fomula that does that already, then im wasting my time. but if not, how would i go about creating it?

One thought i had was to combine the use of a formula, that combines the names, with a code that does the grammar corrections.


but i dont know, thats why im here. lol

please help if you can.

Thank you peoples^_^ i will take you advice. (New2me Bows Respectfully)

i will, i just have to test it out first, i will mark ASAP ^_^