Consulting

Results 1 to 6 of 6

Thread: Need help with loop, concatenate and trim in Excel, VBA

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Newbie
    Joined
    Jan 2021
    Posts
    5
    Location

    Need help with loop, concatenate and trim in Excel, VBA

    Hi,

    I need some help. I have a long list of items in column A with extra spaces, such as: Samsung ', I'd like to loop thru the entire column A, trim out all the extra spaces, I think application.worksheetFunction.Trim(A1), then concatenate the a word "Equipment", the output result as: "Samsung Equipment" in the same column A.

    I was able to do a single item, but not able to get the loop, which I'm not familiar with.

    Much appreciate it,
    Last edited by cp713a; 01-08-2021 at 02:06 PM. Reason: missing tags

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •