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


Joined
Jun 5, 2020
Messages
1
Reaction score
1
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!

1591392559266.png


Many thanks!!!
 
Ad

Advertisements

Joined
Feb 21, 2018
Messages
215
Reaction score
86
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? :)
 
Joined
Feb 21, 2018
Messages
215
Reaction score
86
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))
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top