How to "recode" data in Excel?

  • Thread starter Thread starter zencaroline
  • Start date Start date
Z

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to record data in Excel? 1
recode variable 1
How to randomly split a whole dataset into two sub-dataset? 4
How to RANDOMLY split a whole dataset into two sub-dataset? 3
How to do listwise deletion in SPSS or Excel? 2
how to select out the valid cases without missing data, using listwise deletion 1
How to reduce excel file size ? 2
Unique #s in column, need multiple associated numbers in columns 5

Back
Top