How to find a specific word within a cell in Excel

How to determine if a particular word, number, or phrase exists within a particular cell in Excel, using the isnumber and search function togther

[mohammedateef]

Please zoom/magnify the screen.... would get more views...

[roshanzameer]

Hi,
Is it possible to get the result instead of true or false.

For example:-
If any specific text contains "turkey" in Cell, then the result should be "Country" rather than True Or false.

Please suggest and help

[sonendragupta]

How to filter some alphabets from an excel sheet, for example, we have many data as 0126CS221001, 0126CE221002, 0126EC221001. Now I want to filter as their branch word CS, EC, IT. Sir How plz explain. Plz reply.

[shahrukhjaved]

thanks allot man, you've solved my problem and helped me saving 45mins everyday right before signoff..
++ I've a query is there any way that if we want to do the same operation but now I want to look for two keywords in the column like either turkey or mayo if either of it is present i want TRUE and if both of it are not there then only FALSE

If you could help me wiith that it would be great <3

[rodrigonoschese]

such a simple and powerfull solution...

[veteranx]

Hi, do you have any idea where can I find infos about; How to highlight or find in a TEXT ALL the WORDS that starts or ends ONLY with a certain type of letter? thank you p/s It can be with word, excel, CSS, PHP or HTML

[blenetas]

Hi can you do similar stuff but instead of turkey look for allergies. So if you have your first sandwich" whole wheat, turkey, tomato, mustard" the formula could recognise that sandwich contains allergies as ( gluten, mustard) ? that would be very helpful if you know the way

[arunvikramn]

Pls find the attached file. What im looking to get is province name in coloumn B of "Address" sheet. Province names are listed in the sheet "Province" Any help is greatly appreciated. Thanks for your time.

[kishoregc]

Hi is there any date function to capture present date and should not change on next day, for example {=if (a1="gck", today())}, it will capture the date wen I enter the word gck in a1 is Jan 1st 2017, but wen u see next day it will be changed to Jan 2nd 2017, but my requirement is nt to change the date it should remain as Jan 1st 2017 it self, can u help?

[nopollute]

can I just insert the range (eg: $B$2:$B$700) in case I'm looking whether the word exists or not in column A but row by row? Or any suggestion to count or search the certain word in Column B whether it also exists within Column A.

[ridershortz]

i want to find specific words and bold them . how can i do that ? . such as finding turkey word in full sheet and bold it

[jedelaware]

thank you! i found out i needed to use "isnumber"

[Laila_first]

Hi,
Thanks for the video.
How if I want to know the frequency of word "Turkey" in the cell?

[kishoregc]

Could you help me to find a specific word in sentence with date with in a cell, for example "ABC mail sent on Jan 1st 2017, fgh Mail sent on Jan 4th 2017, " here my question is can I have a formal to find only date when is the mail sent to ABC?

[geethagopalakrishnan]

Good explanation, please continue to share your knowledge

[rachaelstacey]

Thank you, really clear. Needed help for finding text from a survey data.

[magicassassin]

I'm so thankful to you man that you've teach me this awesome knowledge. Thank you thank you thank you 😍😍😍😍😍😍

[Ali-uzqg]

Funny, I look for a solution, try your video, and what a coincidence! Because right now I am slow cooking smoked turkey wings. 😊 OK so my problem is as follows: So I search for the word 'turkey' and it returns TRUE. But I want that it should also type the same word 'turkey' in the same cell, instead of just returning the word TRUE. *I actually want the return to be the exact word I am searching for i.e. 'turkey'.* Is there an appropriate formula?

[HuyNguyen-vnrp]

What if I wanted to search for more than just one word? What if I wanted to see if a cell contains one or more match from a list of words?

[unlocking_potential]

Can you help me about detecting only the last LETTER like 100E to only detect the E in a column?