Excel: How to search for a string in a range of cells?
Solved
Gnagnagna
-
Xavier -
Xavier -
Hello;
I would like to search for a string in a range of cells and have the content of the first cell that matches the criterion returned to me.
For example:
I am looking for "lolo"
In a range of cells (example: A1-A10)
The first cell that meets the criterion is C1 which contains "hello my name is lolo"
Therefore, the cell with the search function returns: "hello my name is lolo"
I can't find how to do that.
I would like to search for a string in a range of cells and have the content of the first cell that matches the criterion returned to me.
For example:
I am looking for "lolo"
In a range of cells (example: A1-A10)
The first cell that meets the criterion is C1 which contains "hello my name is lolo"
Therefore, the cell with the search function returns: "hello my name is lolo"
I can't find how to do that.
Related links:
- Extract a string contained between two quotation marks, Excel 2010
- Extract data from a cell before a comma ...
- Excel: extract the text after a character.
- Excel formula: "IF" a cell contains a word, then?
- Excel: If contains *text part1* OR *text part2 then...
- How to extract a string that appears before the character #