As indicated in my previous post, we can easily change "3" in the formula to any number of words we want. For syntax of the SUBSTITUTE function, please refer to Excel Help text.

Epinn

"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