Adding a suffix to one cell if there is specific text in another cell in the same row

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.

Ah thanks for that!

Is there anyway it can just format column A?

Hi
there are at least two ways to do this
using a formula in a new column to combine something like this
=IF(B1="QC",A1&"_FR",IF(B1="TBAY",A1&"_EN",A1))


or a macro which will permanently overwrite the contents of the original cell, like this:

Please Login or Register  to view this content.

The Macro is perfect thank you!!

Also, can I change the range as I am working with a big spreadsheet eg: "C2:C630", assuming this in the column 1?

Sorry about that!

yes, if you stick to that code structure you should be able to add as many variations as you like; and if you replace A1:A10 with the range to change in MyRange then it will work over whatever range you specify.

If you have a large number of different suffixes it may be simpler to create a couple of arrays rather than coding each one separately. let me know if you'd like to do it this way