I'm working on an excel spread sheet with three columns. Both column A and column B contain some data. Column C is empty. I need to populate column C based on the content of columns A and B. Specifically:
If the string 'ABC' exits s anywhere in the contents of cell A1, then I need the content of cell C1 to be whatever the content of B1 is but pre-fixed with 'UK-'. If 'ABC' does not exist in A1, then C1 should remain blank.
For example if the content of A1 is 'test-ABC' and the content of B1 is 'cat' then C1 should become 'UK-cat'.
What is the formula that will allow me to do this please?