Hi All
Can anyone help, i'm trying to find a formula that looks into a cell for certain set of words, so for instance in the example attached there is a text range in cell B1 "OSNO NOTE OSTS NOPT INT" i want to search in this text range for the words "INT or EXT or INIT", then i want to display the text found in cell C, does anyone know if this is possible ?
Thanks
Jed
Presentation1.jpg
Like this?
=SUBSTITUTE(B2,"OSNO NOTE OSTS NOPT","") and drag it down i guess
Almost, but i just want to find the word INT or EXT or INIT then display just the word it finds ?
Jedski,
Have you tried JieJenn's formula? It does exactly what you say you want it to do - see attached.
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
I think i misuderstood it initially, thats fantastic guys
Thankyou
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks