ExcelBanter - Search a word in the label

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Search a word in the label (https://www.excelbanter.com/excel-discussion-misc-queries/142558-search-word-label.html)

jack

Search a word in the label

I attach a label in each cell. How can I search a word in the label?

Roger Govier

Search a word in the label

Hi Jack

Either use SEARCH or FIND.
=SEARCH("Govier",A1) would return 7, with Roger Govier entered in A1.
The word Govier starts at the 7th character position in the cell.

Search is not case sensitive, Find is Case sensitive.

--
Regards

Roger Govier

"jack" wrote in message
...
I attach a label in each cell. How can I search a word in the label?

All times are GMT +1. The time now is 08:03 AM.