To combine the First name of column A (eg John) with the First name of column B (eg Mary) with an "&" in between (eg John & Mary) into a new column C, use this formula in column C
=A2&" & "&B2
For more info READ HERE
To combine the First name of column A (eg John) with the First name of column B (eg Mary) with an "&" in between (eg John & Mary) into a new column C, use this formula in column C
=A2&" & "&B2
For more info READ HERE
Did you find it helpful? Yes No