This is JUST the sort of thing a machine should do rather than a human! That is, you'll have to teach your machine to do it, but there's no way you should have to do it all manually, a few hundred times.



Getting the extra words out is certainly possible. You may have to play around a little to get it right, but I'm sure it'll be worth the effort. So what are you looking for in the end? Something like this?

That way you can have your mailing label (and I'm sure there's a way to teach Excel to reärrange those to fit any form you have), and still have the phone and email address on the same lines.

So do you want to do this with formulae, or with a VBA program? I might go for VBA just because I like it, but I imagine it's possible with formulae too.

The only really knotty problem that I see here might be how to separate the street from the city, which in your example are on the same line. Or is that an artifact of the way you pasted it in here? Are they in separate lines in your worksheet?