Need Help with Excel

New Contributor

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.



4 Replies


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


Thanks for the quick reply. However - I have done all of that and the formula just doesn't calculate. All I get is the formula in the cell I want the results in.

Any ideas on how to fix that?


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.

You're a Genius!!
Cell was set to text not General!!
Thanks so much!!