Excel function to cut data between to fixed character strings -

i have following text in excel cell:

sampleid: s-2016-011451 submitterid: eirossme sample name: t1 btms - 6/26/16 10:00 pm lot nbr: productid:

i need cut data reads as:

t1 btms 6/26/16 22:00

i can format date using text($cell,"mm/dd/yy hh:mm") can't =mid(...) truncate data between "name:" , " - ".

1st: =mid(b2;63;26) 2nd: =mid(b5;1;8) 3rd: =mid(b5;11;18) 4th: =concatenate(b7;b8)

if want cut between name: , -, use:

=find("name: ";b2) =find(" -";b2)

and then:

=mid(b2, find("name: ";b2)+5;find(" -";b2)-find("name: ";b2)-5)

i.e.:

M16