• 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

shrivallabha

Excel Ninja
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)))
 
Top