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

Hi Paul

one way, place this formula in the column adjacent to your data and change
the A1 to the address of the first line of your text and copy down.
=IF(ISERROR(FIND("prominent",A1)),0,1)
you will see 0 where "prominent" isn't found in the sentance and 1 where it
is.

Cheers
JulieD


"paulfitz320" wrote in message
...

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