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

[benyben123]

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 (:

[brynbaker]

There is no simple formula to do this. The conversion is relatievly simple 9for example source data has given and surnames in that order).
I would deal with the chalenge in VBA (which could be a user defined function, so as easy to call as a built-in function) but there are minor issues with UDFs.
You will need to know that Proper(john a smith) returns 'John A Smith', and the best (IMHO) approach is to always append the second cell value to the first (rather than include a test). The rest is not complex.