Hey folks,
I have zero experience with macros, so I need a little (maybe a lot) of help here.
I have a list of about 10,000 email addresses, separated by commas, no spaces. I need them on an excel sheet in separate rows. Basically like texts to columns, but they should list vertically in rows.
Any help?
Thank you!
Please attach a sample file showing how your data currently looks like.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi Arlu, I'm attaching an example, the only difference is that I have about 10K email addresses...
Example.xls
Thanks in advance for any help!
And all the email addresses are in 1 cell?
Yes, all in 1 cell.Originally Posted by arlu1201
Thanks!
Does anyone have an answer for this?
Thanks!!
Try
Please Login or Register to view this content.
Try this code
Am not sure if it will work in 2003 but you can try.Please Login or Register to view this content.
Jindon - that worked like a charm.
Thank you both for your help!
Glad it worked.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks