Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel - converting address labels to columns
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...- elgeejay
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel - converting address labels to columns
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...- elgeejay
- Thread
- Replies: 11
- Forum: Microsoft: Office
-
Access Update Query not working
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...- elgeejay
- Thread
- Replies: 2
- Forum: Microsoft: Access Forms
