I need to offset the first 3 characters in column O to the left, add them infront of the existing text in K (with parenthesis) ONLY WHEN the value in column F is P1
so in the example below, row 2, 7, and 14 have P1 in column F, after I run the macro column F on these rows will look like:
(D B)...