How to get rid of apostrophe in Entire workbook including Column headings

[sriniprad08]

Hi Team,

Hope you are well. I need help.

How to get rid of apostrophe in Entire workbook including Column headings. Even i tried few formulas from the community or from the website. Its not going.

Please let me know,

thanks,

[binuacs]

@sriniprad08 try the ReplaceChar([location],"'",'') function

[ShankerV]

Hi @sriniprad08 

This can be achieved with the help of multi field formula tool.

Please use the same formula as yours.

Input was: ' in both header and columns too

Many thanks

Shanker V

[sriniprad08]

Thank you @ShankerV . Unfortunately its not working too. Actually when i download the final output as excel or csv its giving the same '.

[sriniprad08]

@binuacs  Thank you so much. It works inside alteryx. But when i download to excel or csv. The problem remains the same.

[binuacs]

@sriniprad08 Can you upload a sample input file to test

[sriniprad08]

please find attached @binuacs  Like this there are many columns

[binuacs · Accepted solution]

@sriniprad08 I am not seeing that issue in my output, i didnt use any tool to remove the extra char

[ShankerV · Accepted solution]

Hi @sriniprad08 

Some time the symbol used in Keyboard might be not equal to the symbol available in .csv file.

Hence I have amended the below workflow

Many thanks

Shanker V

[sriniprad08]

Hi @ShankerV ,

Thank you so much for the kind help. Really appreciate that.

Cheers,

Sri