Announcement

Collapse
No announcement yet.

$25 USD: VBA-TRIM Cells in range in existing macro

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • $25 USD: VBA-TRIM Cells in range in existing macro



    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
    Attached Files

  • #2
    Hi,
    I can look at your request
    GC

    Comment


    • #3
      Thank you GC!!!

      Comment


      • #4
        Hello,
        Code is ready. See PM I sent.

        Comment


        • #5


          Payment received. Code sent via PM.

          Comment

          Working...
          X