View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
EngelseBoer EngelseBoer is offline
external usenet poster
 
Posts: 67
Default return first TWO or THREE words in string

kennel name could be something like
Molosser De Boeren
3 words in the title
most are only 1 word titles
a lot 2
and the occasion 3

but for these i can just copy and past the words really

"Lars-Åke Aspelin" 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




Please explain the "or possibly 3" part of your problem better.

Lars-Åke