I currently have a cell with a person's last name a space and the first name.
I have already done the gramatical formatting, adding a comma between last
and first name. I need to know how to format the whole cell to show caps for
the first letter of the last and first names, and then lower case for all
other letters. In addition, I also need to format the last name only to be
bold. Any help appreciated. My macro work is very limited, good on formulas
though.