When copied, A1 becomes B1 become C1 becomes D1......

Maybe use SPALTE($A1) so that does not happen.

Or copy it once, then use find and replace to change SPALTE( to SPALTE($

Or describe what you are trying to do and get a better formula