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

Search results

  1. J

    Formula Challenge 001 - Return everything in string after first block of numbers

    Hi, maybe it's my version of Excel (2010) but I get 0Australia1484 using the solution outlined. If it's changed to =MID(A4,2+MATCH(1,(CODE(MID(A4,ROW(A$1:INDEX(A:A,LEN(A4))),1))<58)*(CODE(MID(A4&"a",ROW(A$3:INDEX(A:A,LEN(A4)+1)),1))>57),0),LEN(A4)) I get what's expected.
Back
Top