+ Reply to Thread
Results 1 to 7 of 7

VBA expression to extract the text from the beginning of an alphanumeric string

  1. 04-30-2012, 07:54 PM #1
    webfeet2
    webfeet2 is offline
    Registered User
    Join Date
    07-11-2011
    Location
    Gatineau, QC
    MS-Off Ver
    Excel 2010
    Posts
    50

    VBA expression to extract the text from the beginning of an alphanumeric string

    Hello,

    I've edited to change my requirements.

    Does anyone know any vba code that could delete everything but alphabetic characters from a string? Basically, everything but A to Z should be deleted, including all numbers and special characters (!@#$%^&*()).

    Thank you.
    Last edited by webfeet2; 04-30-2012 at 08:17 PM.
    Reply With QuoteRegister To Reply
  2. 04-30-2012, 09:38 PM #2
    Trebor76
    Trebor76 is offline
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,525

    Re: VBA expression to extract the text from the beginning of an alphanumeric string

    Hi webfeet2,

    Do you only want to keep A to Z? What about a to z?

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
    Reply With QuoteRegister To Reply
  3. 04-30-2012, 09:40 PM #3
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: VBA expression to extract the text from the beginning of an alphanumeric string 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 04-30-2012, 09:48 PM #4
    Trebor76
    Trebor76 is offline
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,525

    Re: VBA expression to extract the text from the beginning of an alphanumeric string

    Another way:

    Please Login or Register  to view this content.
    Regards,

    Robert
    Reply With QuoteRegister To Reply
  5. 04-30-2012, 10:05 PM #5
    mikerickson
    mikerickson is offline
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: VBA expression to extract the text from the beginning of an alphanumeric string

    One more

    Please Login or Register  to view this content.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.
    Reply With QuoteRegister To Reply
  6. 04-30-2012, 10:57 PM #6
    webfeet2
    webfeet2 is offline
    Registered User
    Join Date
    07-11-2011
    Location
    Gatineau, QC
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: VBA expression to extract the text from the beginning of an alphanumeric string

    Hi Trebor,

    Thank you!! The code works very well, it was a big help.
    Reply With QuoteRegister To Reply
  7. 05-01-2012, 12:41 AM #7
    Trebor76
    Trebor76 is offline
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,525

    Re: VBA expression to extract the text from the beginning of an alphanumeric string

    Glad to have helped
    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)

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