Hi,

How can I extract first 7 words from cells.

I use formula that can extract first word
=LEFT(A1;FIND(" ";A1)-1)
but I do not know how to modify it to extract more words.