Hi everyone,
I'm a real newbie to Excel-fiddling and am really stuck: Need to divvy up names and addresses that are in a single field into separate columns (for starters). Thanks for sharing your wisdom!
Hi everyone,
I'm a real newbie to Excel-fiddling and am really stuck: Need to divvy up names and addresses that are in a single field into separate columns (for starters). Thanks for sharing your wisdom!
Last edited by mattoid; 10-17-2012 at 01:32 AM. Reason: Previous post incomplete
ok, so what is your question, and what do you need help with?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Sorry, the my first post raced online before I was done with it... Here's the complete request:
I'm a real newbie to Excel-fiddling and am really stuck: Need to divvy up names and addresses that are in a single field into separate columns (for starters). Thanks for sharing your wisdom!
hard to say without seeing what you have?
upload a sample workbook (not a pic) and we can see what we can come up with?
To Attach a File:
1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.
Small sample file attached, showing name/address info that needs to be separated into individual columns. Note that there are two types of entries: personal name and company name. If personal name, their address needs to go into Address Line 1 column, if company name, it needs to go into Address Line 2 column (yikes--and some of the company names list a personal contact after them). I've tried Text-to-Column, extracting via LEFT/RIGHT functions, etc. but I'm guessing some VBA (beyond me) is required here...
Thanks for your assistance--I promised my friend I'd help with this, and am getting a sinking feeling that it's not very workable.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks