Formula to keep specific words only based on position

Hi guys, I am new to excel formulas and I am struggling with it.

I have a line of text, of which I want to keep only the 2nd and 3rd word and remove the rest. for example: cell A1 contains 'I love reading books' . I want to write a formula/vba code whichever is easier to give output in B1 as 'love reading'.

Could someone help me with this? Thanks in advance

at the moment I am able to remove the first word using formula RIGHT(A1,LEN(A1)-FIND(" ",A1))... Struggling with the remaining words.

Good morning IamNewbee

...and welcome to the forum!!

Try (assumes your string is in A1) :

Formula:

Please Login or Register  to view this content.

HTH

DominicB

Originally Posted by dominicb

Good morning IamNewbee

...and welcome to the forum!!

Try (assumes your string is in A1) :

Formula:

Please Login or Register  to view this content.

HTH

DominicB

It works perfectly. Thanks dominicb