- Jun 29, 2012
I have two columns of data 'A' and 'M'. In column 'A' where the first three characters are 1Q_ I Need to replace with "1QT_" but only if the corresponding cell in column 'M' has the value "Day D". Can anyone help? In the table below the 4th entry would require updating.
|Column A||Column M|