extract everything but first and last word

I want a formula that will extract everything in a cell that is not the first or the last word...

In this case the

first "word" is always a date formatted like this ---> XX/XX/XX

last word is always a number

I just want to have everything in between pulled out and put into a adjacent cell.

Hi,

One way

Formula:

Please Login or Register  to view this content.

Maybe this

in B1 and pull formula to the right until you see blanks

=IF(ISERROR(--TRIM(MID(SUBSTITUTE($A1," ",REPT(" ",255)),255*COLUMNS($A:A),255))),TRIM(MID(SUBSTITUTE($A1," ",REPT(" ",255)),255*COLUMNS($A:A),255)),"")

Row\Col	A	B	C	D	E	F	G
1	8/4/2015 last word is always a number 654987	last	word	is	always	a	number

..or if there are several words then

Formula:

Please Login or Register  to view this content.

Or if you would like it to go into one cell use formula below

=MID(A1,FIND(" ",A1)+1,LOOKUP(10^308,FIND(" ",A1,ROW(INDIRECT("1:"&LEN($A1))))-1)-FIND(" ",A1))

Row\Col	A	B
1	8/4/2015 last word is always a number 654987	last word is always a number
2	12/29/2014 just another text string 456665	just another text string