Apr 25 2018 08:56 AM
Apr 25 2018 08:56 AM
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 is recommended for cleaning up data in sheets for a regular use system.
I think formulas in the cells would be too cumbersome.
I could put the cleanup in the Macros.
Is there a code ready made to solve this issues, including ranges.
Or a free third party cleaner available.
Thanks
PervazA
Apr 25 2018 09:34 AM
Hi Pervaz,
You can depend on some native tools such as Find and Replace.
Regards
Apr 25 2018 09:49 AM
Apr 25 2018 10:08 AM
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 macro recorder!