May 03 2021 12:25 PM
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:
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
May 03 2021 12:59 PM
May 03 2021 01:06 PMSolution
Make 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.