Typo
.....If B1 were left blank, then it would pick up all of the text
from A1

Should have read if D1 were left blank.

--
Regards

Roger Govier


"Roger Govier" wrote in message
...
Hi

It is the number 3 in Luc's formula that you would need to amend, to
the number of words you wanted.
It might be easier to refer to another cell, e,g D1, and enter the
number of words required in that cell.
A single change of value here would save having to keep modifying the
formula. If B1 were left blank, then it would pick up all of the text
from A1

=LEFT( TRIM( A1 ),
IF( ISERR(
SEARCH( " ", SUBSTITUTE( TRIM( A1 ), " ", " ", $D$1 ) ) ),
LEN( A1 ),
SEARCH( " ", SUBSTITUTE( TRIM( A1 ), " ", " ", $D$1 ) )- 1 )
)

--
Regards

Roger Govier


"Dinesh" wrote in message
...
Thanks a lot. What criteria do I change if I want to extract 2 words
or 4
words from this formula?

"Dinesh" wrote:

Is their a function to extract first 3 words from a text string?

Thanks.

Dinesh Shah