Hi,
I extract first 7 words from every cell using following formula:
It works but when I have cells with words less than 7 I got #VALUE! error.![]()
Please Login or Register to view this content.
How can I write IF statement that if cells has less than 7 words, cell will be just copied to new cell.
![]()
Please Login or Register to view this content.
Bookmarks