<div>
Try this<br />
=IFERROR(MID(&quot;JanFebMarApr<wbr />&quot;,FIND(A1,<wbr />&quot;JanFebMar<wbr />Apr&quot;,1),3)<wbr />,&quot;&quot;)<br />
<br />
gowflow
</div>


<div>
Hi gowflow I get a blank in the cell and in the formula window #Value
</div>


<div>
Thanks teylyn that is brilliant.<br />
<br />
I cant &quot;accept&quot; on this PC will do that later from home.
</div>


<div>
Sorry small mistake from my part<br />
=IF(A1&lt;&gt;&quot;&quot;,IFERROR(MID(&quot;Ja<wbr />nFebMarApr<wbr />&quot;,SEARCH(A<wbr />1,&quot;JanFebM<wbr />arApr&quot;,1),<wbr />3),&quot;&quot;),&quot;&quot;)<wbr /><br />
<br />
gowflow
</div>


<div>
It's still the same gowflow but the solution from teylyn works for me but thanks for trying
</div>


<div>
ok fine but I don't understand what is the problem now<br />
gowflow
</div>


<div>
gowflow, can you explain your approach? I think you are searching in the wrong direction. As I understand it, cell A1 has some text, and it may contain any one of the month names in question, among other text. &nbsp;So Find() or Search() need to <b>look in A1</b> for any of the values Jan, Feb, Mar, Apr, and if found, return the respective text string. <br />
<br />
Your formula takes the value of A1 and tries to find it in the sting &quot;JanFebMarApr&quot; and then returns the respective text string. But if A1 contains only the text, we get the same result with <br />
<br />
=A1<br />
<br />
cheers, teylyn
</div>


<div>
Teylyn<br />
As always you are great. I totally missed the boat here !!! tks for clarifying and sorry for Jagwarman for having you frustrated with my off-solution !<br />
<br />
gowflow
</div>


<div>
For 12 months<br />
<br />
=IFERROR(INDEX({&quot;Jan&quot;;&quot;Feb<wbr />&quot;;&quot;Mar&quot;;&quot;A<wbr />pr&quot;;&quot;May&quot;;<wbr />&quot;Jun&quot;;&quot;Jul<wbr />&quot;;&quot;Aug&quot;;&quot;S<wbr />ep&quot;;&quot;Oct&quot;;<wbr />&quot;Nov&quot;;&quot;Dec<wbr />&quot;},MATCH(A<wbr />1,{&quot;Jan&quot;;&quot;<wbr />Feb&quot;;&quot;Mar&quot;<wbr />;&quot;Apr&quot;;&quot;Ma<wbr />y&quot;;&quot;Jun&quot;;&quot;<wbr />Jul&quot;;&quot;Aug&quot;<wbr />;&quot;Sep&quot;;&quot;Oc<wbr />t&quot;;&quot;Nov&quot;;&quot;<wbr />Dec&quot;},0)),<wbr />&quot;&quot;)<br />
<br />
Kris
</div>


<div>
I midread the question earlier. Here is a revised one.<br />
<br />
=IFERROR(LOOKUP(9.999E+307<wbr />,SEARCH({&quot;<wbr />Jan&quot;;&quot;Feb&quot;<wbr />;&quot;Mar&quot;;&quot;Ap<wbr />r&quot;;&quot;May&quot;;&quot;<wbr />Jun&quot;;&quot;Jul&quot;<wbr />;&quot;Aug&quot;;&quot;Se<wbr />p&quot;;&quot;Oct&quot;;&quot;<wbr />Nov&quot;;&quot;Dec&quot;<wbr />},A1),{&quot;Ja<wbr />n&quot;;&quot;Feb&quot;;&quot;<wbr />Mar&quot;;&quot;Apr&quot;<wbr />;&quot;May&quot;;&quot;Ju<wbr />n&quot;;&quot;Jul&quot;;&quot;<wbr />Aug&quot;;&quot;Sep&quot;<wbr />;&quot;Oct&quot;;&quot;No<wbr />v&quot;;&quot;Dec&quot;})<wbr />,&quot;&quot;)<br />
<br />
Kris
</div>


<div>
<div class="content wysiwyg-content">
Could an Expert provide the answer to this please. I need to search a string of text and find one of several words.<br />
<br />
i.e. I need to find Jan or Feb or Mar or Apr<br />
<br />
I have the below formula but cannot figure out how to expand this to look for all of the above.<br />
<br />
=IF(ISERROR(SEARCH(&quot;Jan&quot;,A<wbr />1)),&quot;&quot;,&quot;Ja<wbr />n&quot;) <br />
<br />
Thanks
</div>
</div>


Could an Expert provide the answer to this please. I need to search a string of text and find one of several words.

i.e. I need to find Jan or Feb or Mar or Apr

I have the below formula but cannot figure out how to expand this to look for all of the above.

=IF(ISERROR(SEARCH("Jan",A1)),"","Jan") 

Thanks

Search for text in a string

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.