Please assist with syntax for calculated column

Question

Hello,

I am trying to create a calculated column to remove an apostrophe and the & sign from the text in column "Agent name". However I am receiving an error message that the syntax is incorrect. Please assist with correct syntax.

Here is the formula.

=REPLACE(REPLACE([Agent Name],SEARCH("'",[Agent Name]),"1","")([Agent Name],SEARCH("&",[Agent Name]),"1","")

thanks,

Answer 1

@Sherazad Ahmed
Please use following formula in the calculated column.

=REPLACE(REPLACE([Agent Name],SEARCH("&",[Agent Name]),1," "),SEARCH("'",[Agent Name]),1," ")  

Result:

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.