A3
=MID(A3,MATCH(TRUE,EXACT(MID(A3,ROW($1:$28),1),PROPER(MID(A3,ROW($1:$28),1))),0),MATCH(TRUE,EXACT(MID(A3,ROW($2:$28),1),PROPER(MID(A3,ROW($2:$28),1))),0))&" "&MID(A3,MATCH(TRUE,EXACT(MID(A3,ROW($2:$28),1),PROPER(MID(A3,ROW($2:$28),1))),0)+1,255)
entered with Control + shift + enter
its not finnished but time to retire for the night
Bookmarks