+ Reply to Thread
Results 1 to 5 of 5

Macro to remove any numeric characters from just the last value

  1. #1
    Registered User
    Join Date
    07-06-2010
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Macro to remove any numeric characters from just the last value

    Hello,

    Very new to Excel. In fact, this is the first time I have ever really used it and I have gotten this far in about the last 30 minutes:

    Please Login or Register  to view this content.
    I am under a lot of pressure here to create a Macros to change a column in what's called an .ALE file. I could really use some help and I think it would be pretty easy for people here. What I need to do is take the above formula and remove any numeric characters from just the last value, "I13". Then, I need to make that formula into a macros that will operate on an indeterminate number of rows starting with row 13. Can anyone help me?

    I really appreciate any help!
    Last edited by Renfield; 07-09-2010 at 12:06 PM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    re: Macro to remove any numeric characters from just the last value

    Hello Renfield,

    Welcome to the Forum!

    Because you are new I have changed your title to one that better describes your problem.

    As a new member, please take some time to familiarize yourself with the rules.
    Click here for the Forum Rules
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    07-06-2010
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Macro to remove any numeric characters from just the last value

    Okay, will do! Thanks!

  4. #4
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Re: Macro to remove any numeric characters from just the last value

    Hi Renfield;

    Here's a macro that will do what you want.
    I'm assuming that when the macro works on row 14, that it uses N14 and O14 and I14
    I'm also assuming that when you say "indeterminate number of rows" you mean keep working until it hits a blank cell.
    I'm also assuming that you want the results put into Column "P" in the same row with the other cells it used.
    Please Login or Register  to view this content.
    Foxguy

    Remember to mark your questions [Solved] and rate the answer(s)
    Forum Rules are Here

  5. #5
    Registered User
    Join Date
    07-06-2010
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Macro to remove any numeric characters from just the last value

    Thanks you so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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