View Single Post
 
Old 07-31-2013, 07:25 AM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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?

Code:
Col A: Calvary Chapel
       840 Cowboy Lane
       Ellensburg Washington 98926
Col B: 509-925-1651
Col C: taddscheffer@gmail.com
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?
Reply With Quote