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.
[TABLE="width: 540"]
<tbody>[TR]
[TD]Last Name[/TD]
[TD]Middle Name[/TD]
[TD]First Name[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jones[/TD]
[TD]M[/TD]
[TD]Jill[/TD]
[TD]Jill Jones =C2&" "&A2
[/TD]
[/TR]
[TR]
[TD]Abess[/TD]
[TD][/TD]
[TD]Gerard[/TD]
[TD]Jill Jones =C3&" "&A3
[/TD]
[/TR]
[TR]
[TD]ABRAHAM[/TD]
[TD][/TD]
[TD]J David[/TD]
[TD]Jill Jones =C4&" "&A4
[/TD]
[/TR]
[TR]
[TD]Abraham[/TD]
[TD]C[/TD]
[TD]Michael[/TD]
[TD]Jill Jones =C5&" "&A5
[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 540"]
<tbody>[TR]
[TD]Last Name[/TD]
[TD]Middle Name[/TD]
[TD]First Name[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jones[/TD]
[TD]M[/TD]
[TD]Jill[/TD]
[TD]Jill Jones =C2&" "&A2
[/TD]
[/TR]
[TR]
[TD]Abess[/TD]
[TD][/TD]
[TD]Gerard[/TD]
[TD]Jill Jones =C3&" "&A3
[/TD]
[/TR]
[TR]
[TD]ABRAHAM[/TD]
[TD][/TD]
[TD]J David[/TD]
[TD]Jill Jones =C4&" "&A4
[/TD]
[/TR]
[TR]
[TD]Abraham[/TD]
[TD]C[/TD]
[TD]Michael[/TD]
[TD]Jill Jones =C5&" "&A5
[/TD]
[/TR]
</tbody>[/TABLE]
Last edited: