![]() Personally, I enjoy using the Flash Fill tool much more. The Text to Column and Flash Fill tools make it possible to split Microsoft Excel data into more than one column. Select Flash Fill under Editing or use Ctrl + E on your keyboard.Select Flash Fill under Editing or use CTRL + E on your keyboard.Įxcel will automatically fill in the First Name column in our example.įor our second column, we start by typing in the last name of the first contact in the appropriate cell.Choose the Home tab on the Excel Ribbon.Hit Enter to move to the next cell down.In the following example, we type in the first name of the first contact in the appropriate cell. The tool is ideally suited for when you’re dealing with fewer cells. In our example, we’d select the B2 cell.Ĭontent from all the cells selected above is now in separate cells in columns A and B.įor a smarter way to split Microsoft Excel data, consider using Flash Fill. Choose Destination, then add the location for the split content.Notice in the example, the first and last names are no longer shown in the same boxes. Select the Data tab on the Excel Ribbon.Choose all of the cells in column A you wish to split.Using the Microsoft Excel Text to Columns tool, we want to take the first and last names listed in column A and split the information into two new columns, B and C. ![]() In the following two examples, the first and last names are in the same cells, but we want to change this to two. The most obvious example of when you might want to split Microsoft Excel Data from one column to more is when names are involved.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |