May 03 2021 12:25 PM
I have tried to combine two cells into one (first and last names) and i have used all the formulas that "help" suggested, but the formulas won't calculate.
What
May 03 2021 12:39 PM
Let's say you have a first name in A2 and a last name in B2. Enter the following formula in C2:
=A2&" "&B2
This can be filled down if necessary.
P.S. If you prefer to combine the first and last names in the form "Last, First", use
=B2&", "&A2
instead.
May 03 2021 12:59 PM
May 03 2021 01:06 PM
SolutionMake sure that the cell you're entering the formula in is formatted as General, not as Text.
Also, check the Formulas tab of the ribbon. If the Show Formulas button in the Formula Evaluation group is highlighted, click it to turn it off.
May 03 2021 01:15 PM
May 03 2021 01:06 PM
SolutionMake sure that the cell you're entering the formula in is formatted as General, not as Text.
Also, check the Formulas tab of the ribbon. If the Show Formulas button in the Formula Evaluation group is highlighted, click it to turn it off.