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

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

On Mar 27, 1:23 am, "zencaroline" <zencarol...@gmail.com> wrote:
> 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