Copy and Paste - Formula is coming over, but keeping the same value

[Chrisj821]

Field C2 is first name (Jill)
Field A2 is last name (Jones)
create formula =C2&" "&A2 and combines the first and last name with a space.
When I copy this formula and paste (tried every paste option) - It copies the formula and the cell number is increasing - the formula in every one looks great and is what it should be, but keeps the value Jill Jones in every one.
Any help would be appreciated. Thank you.

Last Name	Middle Name	First Name
Jones	M	Jill	Jill Jones =C2&" "&A2
Abess		Gerard	Jill Jones =C3&" "&A3
ABRAHAM		J David	Jill Jones =C4&" "&A4
Abraham	C	Michael	Jill Jones =C5&" "&A5

<tbody>
</tbody>

 

[NeonRedSharpie]

Well, I have two questions...one silly and one serious:

silly: Are all your clients named Jill Jones?

No? Ok fine.

Make sure your formula is truly:

=C2&" "&A2

and not

=C$2&" "&A$2

or

=$C$2&" "$A$2

 

[Chrisj821]

Even is I use this formula =CONCATENATE(C2," ",A2) it does the same thing.

 

[NeonRedSharpie]

Try pressing F9. I bet you're on manual calcs.

 

[Chrisj821]

Haha - no they are all different names - I gave a couple examples above.
Yes, the formula is truly =C2&" "&A2 - copied and pasted them in the above.
It just doesn't make sense - never had anything like this happen before.

 

[Chrisj821]

Thank you so much - F9 did the trick. Really appreciate your help. Have a great day!