Kindly keep discussions within the newsgroup thread for the benefit of all.

I don't know what's possibly happening over there, but this sample
illustrates the earlier suggestion in working order:

http://cjoint.com/?jzbkFUYKn1
natek1234.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

--- natek1234 wrote:

Actually, I need it to just find certain text and
display that text,
my desired results would look something like this
with * around what i
need a formula for:

*"ABC" "(11, 15 DATA, ABC, 22)
DATA1"
*"DEF" "(22, 23 DATA, DEF, 33)
DATA2"
*"CBA" "(11, 11 DATA, CBA, 22)
DATA3"
*"BAC" "(22, 44 DATA, BAC, 33)
DATA4"

your formula above makes these all "ABC" but maybe
im doing something
wrong