How to "recode" data in Excel?

[zencaroline]

Hello,

I would like to recode data in Excel, i.e., making 5 become 1,
making 4 become 2, making 2 become 4, making 1 become 5, to change the
direction of negative-worded item questions.

Might anyone know how to accomplish this task in Excel?

I know SPSS can do this. But I need to recode the data in Excel
in order to do other tasks.

Thank you very much and look forward to your kind reply.

Please take care

Caroline

 

[Pete_UK]

If your number is in A1, then this formula will transform it as you
require:

=6-A1

Copy it down for as many items as you have.

Hope this helps.

Pete