| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search for text then return text
i need a fomula that will search down a specified cells in a column... look
at the words in each cell and then display the text i want. for instance... I have a column with words in it and i want it to search through each cell/word for the letter "P"... then i want it to display a "P". if there are one or many instances where a "P" is in that column I want to only display "P". |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
search for text then return text
Maybe something like this...
=IF(SUMPRODUCT(--(ISNUMBER(SEARCH("P",A1:A20)))),"P","") In this formula case is not a factor. P and p are equal. If you want it so that case is a factor just replace SEARCH with FIND. -- Biff Microsoft Excel MVP "r2rcode" wrote in message ... i need a fomula that will search down a specified cells in a column... look at the words in each cell and then display the text i want. for instance... I have a column with words in it and i want it to search through each cell/word for the letter "P"... then i want it to display a "P". if there are one or many instances where a "P" is in that column I want to only display "P". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested formula to search a text string and return specific text | Excel Worksheet Functions | |||
| vlookup formula fails to return data search item is text | Excel Worksheet Functions | |||
| Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
| Search for first instance of text & return the value | Excel Worksheet Functions | |||
| Return text found in a search | Excel Worksheet Functions | |||
Hybrid Mode
