isnumber

[Xeryar]

=IF(ISNUMBER(SEARCH("Strongly Disagree",B14)),1,IF(ISNUMBER(SEARCH("Disagree",B14)),2,IF(ISNUMBER(SEARCH("Neutral",B14)),3,IF(ISNUMBER(SEARCH("Agree",B14)),4,IF(ISNUMBER(SEARCH("Strongly Agree",B14)),5,IF(ISNUMBER(SEARCH("TBD",B14)),""))))))

The strongly agree is also giving me 4 . Can someone advise . 

[#2]

IF() stops when it finds "Agree" - also as part of "Strongly agree".
Just swap this two parts in the formula.

[#3]

i am sorry i am new in excel it went over my head lol . What am I swapping?

[#4 · Accepted solution]

This two parts:
IF(ISNUMBER(SEARCH("Agree",B14)),4
IF(ISNUMBER(SEARCH("Strongly Agree",B14)),5