View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
r2rcode r2rcode is offline
external usenet poster
 
Posts: 10
Default 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".