• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extract text

Y

ysherriff

Member
Hi, i have the following fixed path and would like to extract the numbers from the text string. For instance, for below, i would like to extract: 97357 and 2203 without using Text to Columns but formula.

Totals for 97357 Westhills Village Health Care
Totals for 2203 GL - Prairie Hills

Thank you for your help. Text extraction is something i have to work on in terms of formula skillsets.
 
Suppose your data in "A2"
In "B2" formula :
=SUMPRODUCT(MID(0&A2,LARGE(INDEX(ISNUMBER(--MID(A2,ROW($1:$25),1))* ROW($1:$25),0),ROW($1:$25))+1,1)*10^ROW($1:$25)/10)
 
You must log in or register to reply here.
Back
Top