Excel Text to Columns, Split Comma Separated List

In this video, I'll show you how to take a simple text list of items separated by commas and convert them over to separate distinct items, each in its own individual cell in Microsoft Excel.

Selina from Houston, Texas (a Gold Member) asks: I've got a text file which contains a list of items separated by commas, how can I turn them into separate values, each in its own cell?

Members

Members will learn how to transpose the horizontal list that goes across columns to a vertical list that goes down a row. You'll also see how to trim leading and trailing space characters, copy and paste values, and concatenate extra text onto each value. 

•  Extended Cut Video - Silver
•  Gold Member Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!

Links

Transpose Axes: https://599cd.com/XLX8
Trim Function: https://599cd.com/XLX1
Copy Paste Values: https://599cd.com/XLX8
Concatenation: https://599cd.com/XLX1

Learn More!

• FREE Excel Beginner Level 1
• Excel Beginner Level 2 for $1.00
• Excel Forum
• Mailing List Notifications for New Videos

Questions?

Please feel free to post your questions or comments below. Thanks.

Keywords

microsoft excel, ms excel, #excel, #msexcel, #microsoftexcel, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, text to columns, split list, separate list of text, comma delimited