Using "mid" between two characters

[sroot]

I have alot of data i am trying to sort into excel and i think i need to use the mid function just not sure how to type this one out right... Here is my example "Variable PCARD0-V9R 2014-08-05 20140711 69.36" assuming this is in A1 what would i do to get everything from 2014 to the last space (this information can always change but it will always be in between a space and the dollar figure) so for this one i would want in another column 2014-08-05 20140711 Any ideas? Thanks!

 

[jduley]

How about this.
=MID(A1,FIND(" ",A1)+1,(FIND("~",SUBSTITUTE(A1," ","~",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))-FIND(" ",A1))

 

[sroot]

That returns PCARD0-V9R 2014-08-05 20140711 i just need 2014-08-05 20140711

 

[jduley]

Sorry, I missed that "Variable" was part of the string. The formula I posted will not start at the correct position as a result.

 

[jduley]

Try =MID(A1,FIND(" ",A1,FIND(" ",A1)+1)+1,(FIND("~",SUBSTITUTE(A1," ","~",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))-FIND(" ",A1,FIND(" ",A1)+1))

 

[skywriter]

Here's another solution:

Excel 2010
	A	B
1	Variable PCARD0-V9R 2014-08-05 20140711 69.36	2014-08-05 20140711
Sheet43

Cell Formulas
Range	Formula
B1	=LEFT(RIGHT(A1,LEN(A1)-FIND("2014",A1,1)+1),FIND("|",SUBSTITUTE(RIGHT(A1,LEN(A1)-FIND("2014",A1,1)+1)," ","|",2),1)-1)

 

[skywriter]

Disregard my above post. After looking at your request again, I see I mistakenly thought data you wanted to abstract always started with 2014.