Lets say in A1 thru J1 we have:
1 2 3 4 5 6 7 8 9 10

In a helper row enter:
=INDEX($A1:$J1,11-COLUMN()) and copy across to see:
10 9 8 7 6 5 4 3 2 1

Finally copy the helper row and paste/special/value back into row 1.


--
Gary''s Student - gsnu200735