I don't see the new sample; if you're like me, that just means you meant to attach it and forgot.

Also, see my previous question, that I posted while you were away: Is this a one-time thing or will you do it again and again? If the latter, you really need to write a VBA program for it. If it's just one time, then I would use the FIND and MID formula (you said you got those working) and then just cut-and-paste the results the way you want them.

But before I recommend something I should see the Before and After photos.