Solution for Find functions to non-case sensitive

Dear Frnds,

I have used the following TRIM and FIND functions to list out a word 'Updated' from the list of values using 'DATED' as my search key, however the results returns only the UPPER CASE 'UPDATED', could you please share your ideas on how to get the non case sensitive text by updating the following rule?

=TRIM(MID(SUBSTITUTE(P1," ",REPT(" ",99)),MAX(1,FIND("DATED",SUBSTITUTE(P1," ",REPT(" ",99)))-50),99)).

Thanks in advance

Thanks Buddy!!!It works

You are welcome

If your issue is resolved. Pleas mark the thread as solved by using Thread Tools found at top of your initial post.

I only find Printable and Subscribe under Thread tools.

One more question on the same formula, earlier version search for only one key word, what if I needs to extract more than one key, say 'dated' and not contains 'dated'?

=TRIM(MID(SUBSTITUTE(P1," ",REPT(" ",99)),MAX(1,FIND("DATED",SUBSTITUTE(P1," ",REPT(" ",99)))-50),99)).

Upload sample workbook, along with manually entered expected output.
To upload file, use "Go Advanced" button and follow "Manage Attachments" hyperlink.

I'm not sure I understand your full requirement.