Excel Tutorial: How To Break Data From One Column Into Two Columns In Excel 2010

- only 19 to learn from me how to finish your projects in minutes instead of hours. Excel Tutorial: How To Break Data From One Column Into Two Columns In Excel 2010 Can Excel separate first name and last name into two columns from one? I get this question again and again so I decided to make a video for everyone to see how easy it is to do in Excel -- kind of you make Excel do your work for you. The first thing you need to do in Excel 2010 is insert a column to the right of the column that you want to split.
To do that select one column to the right right click and click Insert.
Now select column with both first name and last name in it and go to Data menu on your ribbon in Excel 2010.
Click on Text To Columns button choose Delimited click Next and specify what separator should Excel use to break first name and last name. In my example I used space -- the most logical separator in this case. Your next step is to click Next and Excel will do your work for you -- no matter if it is only 10 records or 100000 records you will not have to do any manual work -- Excel will do your work for you. Next time you have a project which requires separating two or more words in one column into several columns -- do not do it manually just watch this video again as a refresher and let Excel do your work for you. Enjoy! Here are more videos with helpful tips.
You might find Excel tutorials I listed for you below useful too. I have Excel Blog - Learning With Excel Queen - you might want to read my posts here:

Источник: rutube.ru