• 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


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

Finding specific text and number in a cell


I have lot of text in a cell and I need to isolate a number - can you help me -
I have provided examples to guide and show you what I mean.

The word before the number we need can both in capital or not or partial.

I have 1000s of such lines so I really need a nice and nity solution

thank you




Excel Ninja
Looks like your workbook has IRM (Information Rights Management) protection on it. I'd recommend uploading without one. Or we will not be able to help you.