I have a some names in row A and a some names in Row B. I want to put both names in row C seperated by a semi colon. But, if there are is not a name in A1 and there is a name in B1 I want C1 to show the values of B1 (without the semi colon). If there is a name in A and not in B I want the value of A in C (without a semicolon). If there are names in both A and B I want them both in C with a semi colon. Sorry to be so confusing!
Bookmarks