Is there GOOD way to reformat what's below into three columns in excel: School; Contact Name; Email ? --thanks.
Alabama A&M University
Edwan O’Neal
edwan.oneal@blah.edu,
Alabama Southern Cmty College
Anne Clanton
aclanton@blah.edu,
Alabama State University
Kamela D. Kennedy
kkennedy@blah.edu,
Athens State University
Tena Bullington
tena.bullington@blah.edu,
Auburn University
Michelle Murphy
murphmi@blah.edu,
Bevill State Cmty College
Sam Sullivan
ssullivan@blah.edu,
1) Copy the data into Excel into column A.
The data should arrive in 3 row sets with a blank row in between.
2) In C1, put this formula and copy down as far as needed:
=INDEX($A:$A, ROW()*4-3)
3) In D1 and copied down:
=INDEX($A:$A, ROW()*4-2)
4) In E1 and copied down:
=HYPERLINK(INDEX($A:$A, ROW()*4-1), INDEX($A:$A, ROW()*4-1))
5) Highlight columns C:E and copy them
6) Select Edit > Paste Special > Values
7) Delete columns A:B
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Hello Tra1a, welcome to the forum.
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem.
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks