In the attached file I have a macro which removes specific text strings from a range of cells to clean up the cells, The data is from survey results exported into in excel from an outside source and there is a lot of "junk" in the cells that needs cleaned up. The macro Sub MyReplaceMacro() will remove the text strings but after there are some leading spaces remaining that I would like removed. I tried a few things but not working the way I would like. Is there a way to incorporate a TRIM function into the macro run on the defined range in the macro = myRange = Range("BQ2:DG" & lastRow)?
10% payment sent