Excel Subtract text after the third space and before the fourth (from between spaces)

[cristi]

Hi,

I'm trying to subtract a text from a string, specifically starting after the third space and ending before the fourth space (the length of the text is not always the same).
So, what I need is to get only the red portion of the text.
Please help!

Many thanks!!!

 

[AmjiBhai]

Hi,

I'm trying to subtract a text from a string, specifically starting after the third space and ending before the fourth space (the length of the text is not always the same).
So, what I need is to get only the red portion of the text.
Please help!

View attachment 13479

Many thanks!!!

If I do it precisely what will I get?

 

[AmjiBhai]

assuming the text is in cell c6....the formula is =IF(ISERR(FIND(" ",C6,FIND(" ",C6,FIND(" ",C6,1)+1)+1)),"3rd space missing",MID(C6,FIND(" ",C6,FIND(" ",C6,1)+1)+1,(FIND(" ",C6,FIND(" ",C6,FIND(" ",C6,1)+1)+1))-FIND(" ",C6,FIND(" ",C6,1)+1)-1))

 

[AmjiBhai]

Some expert from linkedin has reacted in celebration of my input...thanks