G
Guest
I have the following formula in cell C1:
=concatenate(A1," ", B1)
This results in getting the person's first name (A1) next to the person's
last name (B1) in cell C1.
I get the correct answer, but when I autofill the formula down, it just
repeats the first answer (Mary Smith) over and over again. Any suggestions
would be appreciated.
=concatenate(A1," ", B1)
This results in getting the person's first name (A1) next to the person's
last name (B1) in cell C1.
I get the correct answer, but when I autofill the formula down, it just
repeats the first answer (Mary Smith) over and over again. Any suggestions
would be appreciated.