Hi,

I,ve got a lot of data laid out in columns as below in excel. What I
want to do is check for example all sentences that contain the word
"prominent" and then assign that sentence a value in another cell

Would really appreciate any help

Thx

Paul

-- 2004-10-23 don c1 sft hcp - 5f 12k 2 of 13 "prominent, ridden to
lead over 1f out, driven and headed inside final furlong, kept on "

-- 2004-10-17 mus c1 sft hcp - 5f 12k 3 of 13 "in touch on outer,
headway 2f out, ridden over 1f out, kept on inside final furlong "

-- 2004-10-02 eps c1 gd hcp - 5f 17k 9 of 12 "with leaders to over 1f
out, losing place when not much room soon after (op 6-1)"

-- 2004-09-25 hay c1 sft hcp - 5f 20k 9 of 11 "chased leaders over 3f
"

-- 2004-09-14 yar c2 gd - 6f 9k 4 of 8 "raced centre, led, hung left
throughout, ridden and headed over 1f out, weakened inside final
furlong (op 9-2 tchd 5-1)"

-- 2004-09-08 don b1 gd hcp - 6f 32k 5 of 22 "led far side 4f, stayed
on "

-- 2004-09-04 hay c1 gd hcp - 5f 21k 7 of 16 "prominent, ridden and
every chance well over 1f out, weakened inside final furlong "

-- 2004-08-30 eps b gd hcp - 5f 23k 0 of 14 "started slowly, bumped and

hampered well over 3f out, never able to recover (op 10-1)"

-- 2004-07-31 goo b gf hcp - 6f 58k 0 of 28 "raced on wide outside of
near side group, in touch 4f, soon beaten "

-- 2004-07-25 asc b gf hcp - 5f 40k 9 of 24 "raced alone in centre,
well on terms with leaders, faded inside final furlong "


--
paulfitz320
------------------------------------------------------------------------
paulfitz320's Profile: http://www.excelforum.com/member.php...fo&userid=6643
View this thread: http://www.excelforum.com/showthread...hreadid=278208