I'm working on a project where the text is inconsistent. I'm using
=proper(a1) to convert all text to proper case. When I paste the formula in
the cells below, I WANT it to be a relative formula (change with each row).
The formula is appearing correctly, but all pasted rows are giving the same
result as the copied cell. I have tried using paste special to make sure I am
copying only the formula to no avail.

Example:
Cell A1 contains ROBERT
B1 contains =proper(A1) which produces the result I want, Robert
This relative formula is pasted into the rows below (2 to 5000+).
A2 contains paula
B2 shows that it contains =proper (B2) HOWEVER, it is producing the result
of Robert instead of Paula

The only thing that seems to fix it is clicking inside the cell and hitting
return. I cannot do this for multiple columns on spreadsheets exceeding 5000
rows. HELP!