+ Reply to Thread
Results 1 to 3 of 3

Extract Text characters only from a cell

  1. #1
    Registered User
    Join Date
    11-14-2008
    Location
    Brooklyn, NY, USA
    Posts
    53

    Extract Text characters only from a cell

    Hi All,

    This is very similar to my previous post, which was solved. Now that I've extract the numbers, I need to extract the text for the specific work activities, for example 13Z or 9GGG. I'm assuming some variation on this formula:

    =LOOKUP(9.99E+307,--MID(C4,MIN(FIND({1,2,3,4,5,6,7,8,9,0},C4&1234567890)),ROW(INDIRECT("1:"&LEN(C4)))))

    is the solution, but I'm struggling with making the correct alterations.

    Thanks in advance!
    Last edited by judasdac; 05-06-2009 at 12:22 PM.

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

    Re: Extract Text characters only from a cell

    Assuming your string is in A1 (13Z) and the formula provided previously to extract number is in B1 (13) then

    C1: =REPLACE(A1,1,LEN(B1),"")

    (Replace may be safer than Substitute in this instance...)

  3. #3
    Registered User
    Join Date
    11-14-2008
    Location
    Brooklyn, NY, USA
    Posts
    53

    Thumbs up Re: Extract Text characters only from a cell

    That's perfect again! Thanks 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