![]() |
|
#2
|
||||
|
||||
|
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
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? |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Updating dependent Data list display
|
AHB | Excel | 2 | 08-11-2012 08:50 AM |
| Toolbar automatically resetting/rearrange | finalmakerr | Outlook | 0 | 09-21-2011 02:20 AM |
Conditional data validation (list drop-down)
|
click4akshay | Excel | 2 | 04-28-2011 01:51 PM |
| Creating mailing labels from list in excel | wordnoob2 | Mail Merge | 0 | 12-13-2010 03:46 PM |
How to write a macro to find a specified name in a list of data?
|
Jaffa | Excel | 1 | 10-23-2010 02:39 PM |