Hi Everyone,

Long time reader and I have finally signed up to this lovely forum, so hello

I have been googling for quite sometime on this request.

Column 1 (Data example):
001-MUY-000-002-003-MBA-ABC
001-000-000-345-003-MBA-ABC

Column 2
QC
TBAY

So basically I want to do the following: Looking at each row separately, if Column 2 has specific text "QC" to put a suffix "_FR" in column 1. Same goes for specific text "TBAY" to put a suffix "_EN".
So the result being:
001-MUY-000-002-003-MBA-ABC_FR
001-000-000-345-003-MBA-ABC_EN

Is this even possible? if anyone can help me would be greatly appreciated.