How to record data in Excel?

Hello,

I would like to record 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 record 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

.

Relevant Pages

  • How to record data in Excel?
    ... I would like to record data in Excel, i.e., making 5 become 1, ... Might anyone know how to accomplish this task in Excel? ... Please take care ...
    (microsoft.public.excel)
  • Re: How to record data in Excel?
    ... I would like to record data in Excel, i.e., making 5 become 1, ... Might anyone know how to accomplish this task in Excel? ... I know SPSS can do this. ... Please take care ...
    (microsoft.public.excel)
  • How to "recode" data in Excel?
    ... I would like to recode data in Excel, i.e., making 5 become 1, ... Might anyone know how to accomplish this task in Excel? ... Please take care ...
    (microsoft.public.excel)
  • How to "recode" data in Excel?
    ... I would like to recode data in Excel, i.e., making 5 become 1, ... Might anyone know how to accomplish this task in Excel? ... Please take care ...
    (sci.stat.consult)
  • Linking time values
    ... I am conducting a research project in Excel which requires me to record data ... at specific increments of time. ... there is a way to link a cell to another cell so that A captures the ...
    (microsoft.public.excel.programming)
Loading