• 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.

Get Certain Text From a Sentence

Kenshin

Member
PLease need help to get text from the sentence, please take a look at my file


thank you
 

Attachments

  • Extract Certain Text.xlsx
    9.5 KB · Views: 12
This is bit of sledgehammer approach which works with your data. If your data always starts with 0 then below formula can be reduced.

=MID(A3,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A3&"0123456789",1)),FIND("_",A3,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A3&"0123456789",1)))-MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A3&"0123456789",1)))
 
Back
Top