Text Help

[paulfitz320]

Hi,

I,ve got a lot of data laid out in columns as below in excel. What
want to do is check for example all sentences that contain the wor
"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 t
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 1
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 3
"

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

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

-- 2004-09-04 hay c1 gd hcp - 5f 21k 7 of 16 "prominent, ridden an
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 an

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 o
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

 

[JulieD]

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