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