Results 1 to 20 of 23

Thread: Need help removing unwanted commas that sometimes appear in rows in csv files

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #8
    VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,709
    Location
    That beats my 6 lines.
    RC = Rows.Count
    Do 
    Rw = Cells(1, 19).End(xlDown).Row
       Cells(Rw, 15) = Cells(Rw,15) & " " & Cells(Rw, 16) 'Edit for FirstName LastName
       Cells(Rw,16.Delete Shift:=xlLeft
       'Always do bottom Row, It might need it and a lot of code to skip otherwise
    Loop While Rw < RC
    Last edited by SamT; 01-12-2015 at 11:15 AM.
    Please take the time to read the Forum FAQ

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
  •