Forum Discussion
Getting clean data
I am working on a preping expense sheets for import by another ERP. I am running into issues with ( ` ) character. But I suspect there will be other characters ", ' that are in the sheets. What...
Yes True but sorry I forgot to mention;
The users will be other people and we need a solution that is as Automated as possible.
And that is a consideration for the Macro.
Pervaz
The users will be other people and we need a solution that is as Automated as possible.
And that is a consideration for the Macro.
Pervaz
Hi Pervaz,
You can simulate the steps of using Find and Replace to clean up the worksheet from this character ` as follows:
Sub Macro1()
Cells.Replace What:="`", Replacement:="", LookAt:=xlPart, SearchOrder:= _
xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
End Sub
I have not written this macro but have recorded it using the https://support.office.com/en-us/article/Automate-tasks-with-the-Macro-Recorder-974ef220-f716-4e01-b015-3ea70e64937b!