# Extract Text characters only from a cell

1. ## 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.

2. ## 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. ## Re: Extract Text characters only from a cell

That's perfect again! Thanks so much.

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

#### 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