+ Reply to Thread
Results 1 to 4 of 4

Need VBA code TRIM values at end of text in cell

  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Need VBA code TRIM values at end of text in cell

    Dear Experts

    i have set of data download as csv file from site which have alot space in end of text coloumn C:C

    i want do remove space in column C:C depends upon last row of A:A


    Find the attachment.

    Regards
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Need VBA code TRIM values at end of text in cell

    Here's one method that will loop through each row and trim the trailing spaces from each value.
    Please Login or Register  to view this content.
    BSB

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,517

    Re: Need VBA code TRIM values at end of text in cell

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: Need VBA code TRIM values at end of text in cell

    Thanks alot its works!! Solved

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBB Code to Trim Check number from Text
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-06-2022, 03:00 PM
  2. [SOLVED] Improving text to column code to use a TRIM to cleanup further the results
    By PaulM100 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2018, 03:15 AM
  3. Cocktail of Formulas needed to Trim Text. Large text in cell
    By JPWRana in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 02-06-2018, 05:01 PM
  4. [SOLVED] Trim values as numeric not as text
    By werko in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-25-2014, 02:41 AM
  5. Trim code to exit code if cell is empty
    By excellenthelp in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-23-2013, 12:08 PM
  6. Trim Values of a Cell
    By Andrew.Trevayne in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-10-2011, 04:26 AM
  7. How do I trim cell values
    By Jeremy Turner in forum Excel General
    Replies: 6
    Last Post: 06-21-2006, 09:40 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1