+ Reply to Thread
Results 1 to 4 of 4

Remove all non-numeric characters from selection EXCEPT "x".

  1. #1
    Registered User
    Join Date
    12-09-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    3

    Remove all non-numeric characters from selection EXCEPT "x".

    Hi All,

    I need code to remove all non-numeric characters from a selection, except for a lowercase "x". Can you helP/

    I have the range selection:

    Dim X1, X2, X3, MultiRange As Range
    Set X1 = Range("AD:AD" & Lastrow)
    Set X2 = Range("AE:AE" & Lastrow)
    Set X3 = Range("AF:AF" & Lastrow)

    Set MultiRange = Union(X1, X2, X3)
    MultiRange.Select

    but now I'm stuck. Thank you!

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,451

    Re: Remove all non-numeric characters from selection EXCEPT "x".

    Remove all non-numeric characters from selection EXCEPT "x".
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    12-09-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    3

    Red face Re: Remove all non-numeric characters from selection EXCEPT "x".

    Thank you! Worked perfectly!

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,451

    Re: Remove all non-numeric characters from selection EXCEPT "x".

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as 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] Remove text between "\" regardless of number of characters
    By Jaypelt in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-30-2012, 07:48 PM
  2. [SOLVED] Need to remove first two characters of column and replace with a "U"
    By arashn in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-23-2012, 06:21 PM
  3. [SOLVED] remove all characters to right of "-" character, including "-"
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-27-2012, 02:43 PM
  4. Replies: 3
    Last Post: 07-17-2006, 02:20 PM
  5. "combo box- numeric characters"
    By adam.ronalds in forum Excel General
    Replies: 1
    Last Post: 02-15-2005, 10:27 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1