Thread
:
text filtering formula???
View Single Post
#
3
Posted to microsoft.public.excel.misc
Garth
external usenet poster
Posts: 11
text filtering formula???
I wish... the name could be anywhere in the line of text. Thanks for the
effort.
"Sandy Mann" wrote:
Is the name always at the end of the line of text? If so use something
like:
=MID(A1,FIND("is ",A1,1)+3,255)
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Garth" wrote in message
...
I'm trying to find a formula to search for specific words in a line of
text
and show the found word in a single cell.
For example the formula would search for "Joe" and "Mary" and "Steve" in a
single line of text. The text, to be filtered, might be as follows (The
students name is Mary.) The result of the search would have found "Mary"
and
now show "Mary" in the cell. If the text to be filtered would have said
(The
students name is Steve) the cell would show "Steve".
Does anyone know how to do what I'm trying to do?
Reply With Quote
Garth
View Public Profile
Find all posts by Garth