Help me create the right name in a dedicated rubric - derived from first, middle, and last

Hi.
I need help.

I have a few sources of info - first name, middle, last.
Each source has it differently.
I need to combine all to a single rubric that will show the full name in the right way.

Here:


Rubric D -------------- Rubric E
john smith -------------- smith
john -------------- smith
john A -------------- smith
john a. -------------- Smith
John A. -------------- smith
john a -------------- Smith
john a smith --------------



I wanted to ask if there is a forumal that can take all this data, and extract a proper way:

John A. Smith


Please help if you can (: