Search

Share your knowledge. It’s a way to achieve immortality.

Samah Hossam Eldin [SHE-Share the Knowledge]

Category

Excel

Check if cell in Excel contains numbers with a text

Hello ,   If you want to check if the cell contains numeric numbers with the text use the below formula =COUNT(FIND({0,1,2,3,4,5,6,7,8,9},A2))>0 You will get True Or False as below   enjoy 🙂

Chek if Cell contains specific text

Hello ,  Do you want to classify your data using searching for specific text in cell here is the way: To check if a cell contains specific text, you can use the SEARCH function together with the ISNUMBER function. =ISNUMBER(SEARCH("School"|K2)) More clarification: The SEARCH... Continue Reading →

How to Find Last Word from cell in Excel

Hello , I was working  in reformatting some data to ingest it to DB, I love to work in excel I have a column and need to get the last word from it, for sure "the last word " not... Continue Reading →

Powered by WordPress.com.

Up ↑