I am totally perplexed. Excel spreadsheet with three columns. Column B has last name and column C has first name. I want to concatenate those to into last, first.
Here is the confusion. I know the formula and here is what is in the cell.
That produces exactly that:
=CONCATENATE(B2,", "+C2) and not the results of the formula. As I build it using the "Insert Function" button I can see the results is what I want but when I press enter only the formula shows. I build it from scratch by typing all in and get the same. What am I missing?
Formatting? Is so what?
Thanks in advance.