Value does not fill down (copy) properly.
 

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

Most likely the column you are dragging the formula into is formatted as
text, try taking all the entries in that column out, format as General, then
enter again,
Regards,
"Karina" wrote in message
...
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

Good heavens, how simple was that?

Thank you very much!!

Sometimes we make things TOO complicated, when they really are not.

Whew.
~K


"Alan" wrote:

Most likely the column you are dragging the formula into is formatted as
text, try taking all the entries in that column out, format as General, then
enter again,
Regards,
"Karina" wrote in message
...
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