I dont know how to explain correctly ) so I have A, B and C columns in A column I am using this formula ="("&MID(B1,8,LEN(B1)-15)&")" it takes value from B removes first and last characters and puts () signs, how can I do modify this formula to look at C value also and if C is not empty take values from C but I dont want first and last characters removed like in formula, just add () signs.
Thanks!