how about this one ??

=LEFT(A1,FIND(" ",A1,FIND(" ",A1)+1))


On Sep 7, 4:06*pm, 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