Need to merge, proper and trim

[nj2691]

hi guys,
I need to combine column A and B which contains first name and last name and have to make it in sentence case and trim for space... probably i'm facing more than 400 to 500 job like this,,, help me in this issue...

basically i'm new to macro...