If functions with Text

[Karen]

How would I do the following in Excel.

I have a column with the following type of text values -
either Y or N comming from a database.

YNNNYYNN
NNYYYNNN
NNNNNNNY
YYYNNNNN
etc.

I need to convert the date as follows for example
if A1 = "YNNNYYNN" then A1 = "ClassA"
elseif A1 = "NNYYYNNN" then A1 = "ClassB"
elseif A1 = "NNNNNNNY" then A1 = "ClassC"
etc.
then repeated for each row

How do I do this in Excel ?

Many thanks

 

[Frank Kabel]

Hi
If you wanr to change A1 directly use 'Find - Replace' and repeat this
opersation three times for your values