Hi,

I extract first 7 words from every cell using following formula:
=LEFT(A1,FIND("@@",SUBSTITUTE(A1," ","@@",7),1)-1)
It works but when I have cells with words less than 7 I got #VALUE! error.
How can I write IF statement that if cells has less than 7 words, cell will be just copied to new cell.

columna A                                                       Column B
dad sddas sadsa dasdas ddadd sd 7 sddasd          dad sddas sadsa dasdas ddadd sd 7     
dasdas dsda sddas                                           dasdas dsda sddas