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

Finding specific text and number in a cell

Hi

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

David
 

Attachments

  • Excel - ALM - Chandroo.xlsx
    37 KB · Views: 17
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.
 
Back
Top