If functions with Text

  • Thread starter Thread starter Karen
  • Start date Start date
K

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
 
Hi
If you wanr to change A1 directly use 'Find - Replace' and repeat this
opersation three times for your values
 
Back
Top