Hello ,
I have an excel formula eg.
=IFERROR(RIGHT(F13 F15,LEN([User Name])-SEARCH(“]”,[User Name])),[User Name])
I need to put an extra set of double quotes around any text in one set of double quotes. SO my output should be:
=IFERROR(RIGHT(F13 F15,LEN([User Name])-SEARCH(“”]“”,[User Name])),[User Name])
How can this be achieved?
Thanks much