maybe i need put it better

compare..eg (and anything less or more)

Kennel name Molosser De Boeren
animal Name Queen of Sheba
thus name = Molosser De Boeren Queen of Sheba

v/s
Kennel name Aricon
animal Name Sweet Pea
thus name = Aricon Sweet Pea


"Rick Rothstein" wrote:

You were asked a couple of times about the "or possibly 3" part of your
question and you said you would work around it. That might not be necessary
assuming you asked the "wrong" question. Is your actual question "How do I
return all but the last word in an entry?" That is, is the text following
the part you want **always** a single word (containing no internal spaces)?
If so, you can use this formula to return the words in front of it...

=SUBSTITUTE(A1," "&TRIM(RIGHT(SUBSTITUTE(TRIM(A1)," ",REPT(" ",99)),99)),"")

If your newsreader breaks the above formula into two lines, the break will
have occurred at a blank space in the formula, so make sure you include it
when recombining the line.

--
Rick (MVP - Excel)


"EngelseBoer" wrote in message
...
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