Auto code - Convert phrases to numbers

[bdecola88]

I have results from a survey where the answers are slightly disagree, strongly disagree, slight agree, and strongly agree. I need a way to auto-code the answers in that, "slightly disagree" coverts to "1", "strongly disagree" converts to "2", and both "strongly & slightly agree" convert to "0". Not sure of the best approach here....

[Gregb11]

Well, one way could be to just use "Replace" (ctrl-h) and do a replace-all for each answer.
Another would be to enter an "IF" or "IFS" statement that handles all the changes. (IF(A1="slightly disagree",1,...)

[bdecola88]

Thank you, Gregb! I will try these methods!

[shg]

... and both "strongly & slightly agree" convert to "0".

Lumping those together violates the interpretation of a Likert scale response.