Ok. While we're waiting for that to happen, here's one question: Do you expect to need to rearrange the address information like this only once or twice, or many times? If you're going to do it once a week for the rest of your life (so to speak), then it should be in a VBA program. If it's just this once, you may as well do it manually with copy-and-paste. VBA takes more trouble, but it's infinitely more flexible and (for some people at least) much more fun as well.