Hi Bob,

Your formula works well except for values like AM(LR) and AM(RLC) which I would like to convert to MF too (since it contains a M).
There does not seem to be a way to work round your formula for this?

And Concatenate will work if values for the two columns are different. But if the values in the two columns are the same (e.g. MF and MF), how can I make it to recognise that and return MF instead of MF,MF?