| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search a word in the label
I attach a label in each cell. How can I search a word in the label?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search Multiple columns for criterion asterisk (*) and Return Numeric Label | Excel Worksheet Functions | |||
| How can I have Excel cells populate a Word label template? | Excel Discussion (Misc queries) | |||
| Convert Word Label to Excel | Excel Discussion (Misc queries) | |||
| need formula to search column for a word and return another word | Excel Discussion (Misc queries) | |||
| how do I label columns with a word, not alphabetical | New Users to Excel | |||
Linear Mode
