I need to combine last name and first name fields, and am using this formula:
+B2&","&C2
The B column is the last name, and C column is the first name.

My first glitch is, when I enter that formula, the forumula RESULT does not
display in the cell, only the formula itself.

My second glitch is, when I try to copy that formula down the rest of the
column of data, it should reflect the descending row numbers (ie., B3 & C3,
then B4 & C4, etc.). But only the C column increases accordingly, the B
column remains B2 and does not increase.

What, praytell, have I done wrong?

Thank you very much in advance.

~K