Shadow_Thief Posted January 27, 2009 Share Posted January 27, 2009 I have webpage with a list of info in this format FirstName ( First Middle Last; username) FirstName ( First Middle Last; username) FirstName ( First Middle Last; username) now what i want to do is take this and use it as a mailing list. i would like to harvest username FirstName ( First Middle Last; username) and add the @domain.com after it. How can i do this is a way that is no tedious? Thanks for the help Dave Link to comment Share on other sites More sharing options...
0 timmmay Posted January 27, 2009 Share Posted January 27, 2009 Use Excel. Download a tool called ASAP Utilites. It has some very good features which you can use to split up the data and move them into new columns etc... Link to comment Share on other sites More sharing options...
0 Shadow_Thief Posted January 28, 2009 Author Share Posted January 28, 2009 Thanks for the tool, I have downloaded it, but im not an excel guy and am a bit lost on how to use it. FirstName ( First Middle Last; username) For example I have all the above info in one colunm. How do I say "get everything after the ; and before the )' and seperate the username into its own colunm? Thanks, Dave Link to comment Share on other sites More sharing options...
Question
Shadow_Thief
I have webpage with a list of info in this format
FirstName ( First Middle Last; username)
FirstName ( First Middle Last; username)
FirstName ( First Middle Last; username)
now what i want to do is take this and use it as a mailing list.
i would like to harvest username
FirstName ( First Middle Last; username)
and add the @domain.com after it.
How can i do this is a way that is no tedious?
Thanks for the help
Dave
Link to comment
Share on other sites
2 answers to this question
Recommended Posts