Left function

D

dillonke

Hi,
I'm moved from Excel 2000 to 2003 and now I find that the Left an
Right functions are not working correctly. They work OK if I type the
in one cell at a time but if I use copy/paste it just reproduces th
same result in every cell. This happens even if I use past
special/values as well!

Any ideas appreciate
 
J

jeff

Hi,

I'm sure you've checked, but do you have relative
reference, like =LEFT(A1,4); or =LEFT($A$1,4)?

The $'s will keep the same reference cell so your
copy/paste won't 'move' along with your new cells.

Otherwise, it works for me....

jeff
 
Top