+ Reply to Thread
Results 1 to 9 of 9

macro to use for excel to clean and trim coumns a2:a100

  1. 09-06-2017, 05:13 PM #1
    David713
    David713 is offline
    Registered User
    Join Date
    07-27-2017
    Location
    HOUSTON
    MS-Off Ver
    2013
    Posts
    15

    macro to use for excel to clean and trim coumns a2:a100

    Macro to use for excel to clean and trim columns a2:a100.
    Reply With QuoteRegister To Reply
  2. 09-06-2017, 05:15 PM #2
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,470

    Re: macro to use for excel to clean and trim coumns a2:a100

    What about it?
    You know there are actually people reading this right?
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
  3. 09-06-2017, 05:28 PM #3
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: macro to use for excel to clean and trim coumns a2:a100

    @David713

    how about adding an excel file, and add manualy the expected result in your file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  4. 09-06-2017, 05:41 PM #4
    David713
    David713 is offline
    Registered User
    Join Date
    07-27-2017
    Location
    HOUSTON
    MS-Off Ver
    2013
    Posts
    15

    Re: macro to use for excel to clean and trim coumns a2:a100

    I want to put a macro that allows me to clean and trim formula for columns a2:a100 but I don't know how to do this.
    Reply With QuoteRegister To Reply
  5. 09-06-2017, 05:42 PM #5
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: macro to use for excel to clean and trim coumns a2:a100

    for columns a2:a100
    Probably you mean rows a2:a100.
    Reply With QuoteRegister To Reply
  6. 09-06-2017, 05:48 PM #6
    David713
    David713 is offline
    Registered User
    Join Date
    07-27-2017
    Location
    HOUSTON
    MS-Off Ver
    2013
    Posts
    15

    Re: macro to use for excel to clean and trim rows a2:a100

    I would like to see a macro that uses clean and trim for rows a2:a100 but I don't know how.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 09-07-2017, 09:11 AM #7
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,470

    Re: macro to use for excel to clean and trim coumns a2:a100

    Try this,

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 09-07-2017, 09:18 AM #8
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,115

    Re: macro to use for excel to clean and trim coumns a2:a100

    Quote Originally Posted by David713 View Post
    Macro to use for excel to clean and trim columns a2:a100.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  9. 09-07-2017, 12:02 PM #9
    David713
    David713 is offline
    Registered User
    Join Date
    07-27-2017
    Location
    HOUSTON
    MS-Off Ver
    2013
    Posts
    15

    Re: macro to use for excel to clean and trim coumns a2:a100

    This worked for me. Thank you.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using TRIM, SUBSTITUTE & CLEAN
    By scarames in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-18-2014, 03:13 PM
  2. When TRIM() and CLEAN() fail.
    By fhalejr in forum Excel General
    Replies: 7
    Last Post: 01-02-2014, 02:12 AM
  3. [SOLVED] when updating sheet1 a1:a100, auto updates sheet2 a1:a100.
    By chestersneakers7 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-15-2013, 08:09 AM
  4. [SOLVED] Clean and Trim Not Working
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-05-2013, 07:14 PM
  5. [SOLVED] Clean Trim Proper Function Using a Macro
    By kamalthakur in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-14-2012, 09:06 PM
  6. How-to SUM(A1:A100)-SUM(LARGE(A1:A100,{1,2,..,n})) with n being a variable?
    By Coume in forum Excel General
    Replies: 5
    Last Post: 03-22-2010, 01:35 PM
  7. Clean and Trim
    By tl7410 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2009, 03:03 PM
  8. Excel Trim , Clean or IsNonText function doesn't work
    By munzer1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-28-2007, 06:25 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1