nothing
where i need it i will need to alter the scriping for only those applicable
i will use Gary's Student's reply

thing is i am dealing with near 37,000 entries (dogs)
hundreds of breeders
so am running scripts for a variety of reason
to colate the data into excel - then tab delim it
and then upload to an online database

in his instance - it is collecting the Breeders kennel Name form the dogs name

"Ron Rosenfeld" wrote:

On Sun, 7 Sep 2008 04:06:01 -0700, EngelseBoer
wrote:

similar to...
=LEFT(A1,SEARCH(" ",A1)-1)

but where the 1st 2 (or possibly 3) words are required to be returned
what do i need to change
or what script do i need here

A B
100 AKER BALTO 100 AKER
100 AKER BASTION 100 AKER
100 AKER BODECIA 100 AKER
DE WET SISQO DE WET
DE WET SKYE DE WET
DE WET STOFFEL DE WET
EL SHADAI LULU EL SHADAI
EL SHADAI MARMITE EL SHADAI
EL SHADAI MIMI EL SHADAI



What determines if you want to return two vs three words?
--ron