I am trying to compile an email list that I have and it needs to be in a different format than I currently have it. Currently the list is all in column A and reads like this:
Email@domain.com;First Last
I need it to be separated out so that column A is the email address, column B is the First Name, and column C is the Last name.
Any help with creating a macro or the best way to get this done I would really appreciate it. Thanks!
You should be able to do this using Text To Columns and choosing both Space and Semi Colon as your delimiters.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
That worked great. thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks