Recent content by elgeejay

Thanks, CautionMP. I copied the code into my Excel VBA editor and ran it and... it almost works! It's very fast and very close to working. The problem is probably that my original data is not all that clean, but what is happening is that the names are coming out on the wrong row; i.e., the...

I initially posted this in the Excel forum and got several suggestions. However, a programmer who responded provided one possible solution (below) but also suggested that I “Post it in the Office VBA forum. What I [he] posted here could be done in VBA but would require a bit more detail.” I...

Thanks for all the input! I thot perhaps this was something that others regularly encountered and that there might be a more or less "standard" solution. Clearly that is not the case. The mailing list contains about 1,000 addresses, so doing it manually would be quite time-intensive. I will...

Thanks for the quick reply. Yes, I wish I could. But the person who created the list typed them one-by-one into a Word label template from a handwritten list. I sure don't want to have to cut/paste everything.

Here are examples of 3 and 4 line addresses in a Word file of labels that I have imported into Excel. Now, I need to convert the 3 and 4 line addresses to columns in Excel; e.g., col headings like: Salutation/Company/Street/City/State/Zip (some with 5 digit Zip, some with Zip+4). There is...

Trying to use update query to change all occurrences of telephone exchange (NOT Area Code) in field Phone1 from 978 to 571 (e.g., (405)978-3345 to (405)571-3345). Data is stored as xxxxxxxxxx. To select records I'm using: mid([Phone1],4,3)="978" -- this works fine. For "Update to" I'm using...