Cell A1 contains:
I want to replace “(a)” by “@”
Formula used in cell B1:
I am using comma as separators and created the formula with the wizard
which is “invalid name”
The string in A1 is text, verified by adding text “(a)@” using the formula:
which is correct.
What is wrong? What do I need to do?