The sign is show in excel cell just before the context. The replace method
is doesn't work as the sign could be see on fx (formula bar) but not be see
on the cell.

"Sheeloo" wrote:

Where do you see that sign?

Can you give an example?

If it is in Excel cell then you can replace it...
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Unknown User" wrote:

How to remove the symbol sign like ' when the data is exporting from
accounting software to excel? I did tried from replaced method but it
doesn't work as the format of the file.

Your assistance is really help. Thank you.