How to locate numerous words in Microsoft Excel 2021?
How to locate numerous words in Microsoft Excel 2021?
Hello,
You have numerous Excel cells with text data and wish to locate cells that include specific keywords in any order. For instance, you want the cell with the text "reusable" and "plastic" to point to A6, or cells containing "water", "wood", and "leather" to point to A3. How should this be done in Excel 2021?
This function is intended for use in a word processor or database tool.
Not homework or test question. I am just asking how to find words in excel. It is just a find feature that exist in all software, browser etc...
All the cells are just examples.
I usually use Ctrl+F and the [Find and Replace] will popup, Ctrl+F can only find a single word e.g. [water] in any cell or multiple words in a row e.g. [Water bottles can be either disposable or reusable], I am unable to search for cells that contain these 2 words "disposable" and "bottles", A4 cell and A5 cell will not be shown in the result.
For example, I want to search for 2 words "disposable" and "bottles" and see A4 cell and A5 cell in my result.
A4 cell contents is: Water bottles can be either disposable or reusable.
A5 cell: Disposable water bottles are often sold filled with potable water, while reusable bottles are often sold empty.
In Ctrl+F feature, there is no way to input [disposable] and [bottles] or [disposable bottles] or [disposable/bottles] to show A4 cell and A5 cell as the result, I just want to tell excel please show me the cells that contain these 2 words [disposable] [bottles] (in any order and they need not be consecutive words and can have other words in between)?
I guess this is not some formula or whatever complicated stuff for someone who has more knowledge for excel. Maybe there are some advanced settings in Ctrl+F or somewhere that can do what I want.
I launch an excel file and search for cells that include the specified phrases, such as [disposable] [bottles], in any arrangement and without requiring them to be adjacent. The information is already present in the spreadsheet.
The issue lies with Excel's handling of data when it contains text inside cells. The question explores whether the problem stems from Microsoft Word or Notepad, checking if specific keywords can be entered to guide the software. It asks for the exact line where "disposable" and "bottles" appear in any order, regardless of spacing.
It can be achieved in Excel.
However, Excel serves as a powerful calculator but is not ideal for word processing or database tasks.
For Excel, explore the IF and ANDIF functions.
Once more, consider the foundation of this approach.
Where could the results be directed?
How extensive is the dataset you're handling?
The tutorial link offers detailed guidance on locating text within Excel cells.
Your task involves two main steps:
1) Identify cells that include a particular word.
2) Develop logic to detect cells containing both a specific word and another target word.
Begin with the first step, then build upon it using the insights gained.
If issues arise, capture screenshots of your spreadsheet to illustrate formulas and formatting.
Upload the images via imgur for review.
I believe people are getting too caught up in details. My question is straightforward: if I need to find cells containing the phrases [disposable] and [bottles] in any arrangement or surrounded by other words, the displayed results will be formatted on A4 or A5 pages. What should I do? (Perhaps there are unknown settings or plugins that explain why I’m asking this)
My A1 to A6 cells contain the following information:
A1 cell: A water bottle is a container used to hold liquids, mainly water, for transporting drinks while traveling or away from water sources.
A2 cell: Water bottles are typically made from plastic, glass, metal, or a mix of these materials.
A3 cell: Historically, water bottles could be made from wood, bark, or animal skins like leather, hide, and sheepskin.
A4 cell: Water bottles can be disposable or reusable.
A5 cell: Disposable bottles are often sold filled with water, while reusable ones are usually sold empty.
A6 cell: Reusable bottles help reduce plastic waste and carbon emissions.