String manipulation - Uipath Studio

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 :slight_smile:

Hello @kaurM ,

Use “CHAR(34)” within formulas where you need to output quotation marks.

Hope it helps!
Best regards,