I looked and found lots of things really close to what I want to do - but nothing that is quite "it".

I have an Excel file. In that file are "First" "Spouse" and "Proper" fields...

"First" is his or her first name.
"Spouse" is his or her husband or wife's first name.
"Proper" is their last name.

THE GOAL is to print Bob and Betty Smith - or just Bob Smith if the "Spouse" field is blank.

My PROBLEM is that I need to be sure the 'and' does not print if "Spouse" is blank...

- I already discovered how to make their names into Mixed Case where they are all caps in the excel file. Did that with PROPER(field) and that may be adding to my confusion when I try to use the expression editor.