I have two columns of names (his & hers) and I would like to establish
a column with both names connected by "&". I have accomplished this but
would like to have just his name if there is no her.

Here is my current formula C2&" & "&E2

How can I eliminate the "7" and "E2 if there is a blank in E2

Thanks