Airehead Posted January 4, 2017 Share #1 Posted January 4, 2017 Excel gods, I need help please. I have a really long list of names that are in one column like this---AIREHEAD, SHENNON I really need them in two columns. I know you can do this using text features but I can't remember how. Can someone please tell me how to automatically split these? Link to comment Share on other sites More sharing options...
Ralphie ★ Posted January 4, 2017 Share #2 Posted January 4, 2017 Oh man, your late, so jsharrt has probably gone home. Uncle Google is your best bet! Here, lmgtfy! brb Link to comment Share on other sites More sharing options...
Ralphie ★ Posted January 4, 2017 Share #3 Posted January 4, 2017 https://www.google.com/search?client=ubuntu&channel=fs&q=excel+convert+comma+separated+list+to+rows&ie=utf-8&oe=utf-8 Then just cut half and paste to get two columns. Link to comment Share on other sites More sharing options...
Airehead Posted January 5, 2017 Author Share #4 Posted January 5, 2017 Thanks I will let you know. I am exceling and then mail merging from multiple fields and trying not to lose the frickin calculations. Link to comment Share on other sites More sharing options...
jdc2000 Posted January 5, 2017 Share #5 Posted January 5, 2017 Instructions on how to do this: https://support.office.com/en-ie/article/Split-text-into-different-columns-with-the-Convert-Text-to-Columns-Wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7 Note: You should make sure that ALL of the cells in the column have a comma in them. 1 Link to comment Share on other sites More sharing options...
jsharr ★ Posted January 5, 2017 Share #6 Posted January 5, 2017 You need to use the data tab in Excel and the text to columns feature. If you can email it to me in the morning I will do this for you. http://www.quepublishing.com/articles/article.aspx?p=2027553&seqNum=5 2 Link to comment Share on other sites More sharing options...
maddmaxx ★ Posted January 5, 2017 Share #7 Posted January 5, 2017 Wut? Wait. Jsharr is good for something? 3 Link to comment Share on other sites More sharing options...
tybeegb Posted January 5, 2017 Share #8 Posted January 5, 2017 Sigh. I miss Excel. Not! 1 Link to comment Share on other sites More sharing options...
JerrySTL ★ Posted January 5, 2017 Share #9 Posted January 5, 2017 I'm a minor deity in Access. I could do it there for you. 3 Link to comment Share on other sites More sharing options...
jsharr ★ Posted January 5, 2017 Share #10 Posted January 5, 2017 1 minute ago, JerrySTL said: I'm a minor deity in Access. I could do it there for you. You are way too old to be a minor deity. You should consider yourself a senior deity. Link to comment Share on other sites More sharing options...
Airehead Posted January 5, 2017 Author Share #11 Posted January 5, 2017 Got it-- thanks! My folks can all get a raise now. 2 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now