Hello everyone,

I have a problem that I couldnt figure out.


For example, the values (5- Likert scale) I have in the first column:

strongly agree
agree
undecided
disagree
strongly disagree
disagree
disagree
agree
undecided
agree
.
.
.
.
.
etc.


And each value has a rep. number.

strongly agree=1
agree=2
undecided=3
disagree=4
strongly disagree=5

What I want to do is, for example

if the first cell is "agree", in the next colum it should be seen as "2";

in the second cell, if the value is "strongly disagree", it should be "5".

Is there a formula to do this? I really appreciate any help.

Molly.