+ Reply to Thread
Results 1 to 3 of 3

Extract alpha name with spaces from a mixed alpha-numeric string

  1. #1
    Registered User
    Join Date
    06-14-2010
    Location
    Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Extract alpha name with spaces from a mixed alpha-numeric string

    Hi All!

    I have a list mixed alpha numeric strings in column A:

    Example:
    12345Curt Connely7890
    584Carl Carlton9874456
    61235467123546Christopher Corey123564234

    What I want is a list of the the alpha characters in column B:

    Example:
    Curt Connely
    Carl Carlton
    Christopher Corey

    Can anybody help me get the desired output?

    Thanks!

  2. #2
    Registered User
    Join Date
    01-25-2008
    Location
    The Netherlands
    MS-Off Ver
    2002, 2003, 2007
    Posts
    94

    Re: Extract alpha name with spaces from a mixed alpha-numeric string

    Hi there,

    I don't think there is an built-in function in Excel that dooes this, so I wrote one.
    Please find attached the .xls file

    You can find the custom built functon in module 1 in the Visual Basic window

    have fun

    J.
    Attached Files Attached Files
    J.

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Extract alpha name with spaces from a mixed alpha-numeric string

    Must be a better way but I can't think straight having just sat through the England vs Algeria match... shudder.

    Please Login or Register  to view this content.
    where A1 holds string..

    or given use of XL2007 you could use 10 embedded SUBSTITUTEs

    Please Login or Register  to view this content.

+ 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