Text combining

[SWEENEYfd]

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 "&" and "E2 if there is a blank in E2
Thanks

 

[Max]

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 "&" and "E2 if there is a blank in E2
Thanks

One way which covers all possibilities within cols C and E ..

Try in say, F2:
=IF(AND(C2="",E2=""),"",IF(C2="",E2,IF(E2="",C2,C2&" & "&E2)))
Copy down