We use lists of text all of the time in Excel, but those
lists do not always come neatly formatted.
Thankfully, there is a setting in Excel in called Text to Columns that
can make the task of splitting information into multiple columns a simpler
task. For example, let’s say you are
given a list of names in Excel that is not sorted and has the whole name in one
cell. This can be especially frustrating
when you need to sort by last name, but now with this trick you do not need to
retype all the information and here is how.
- First select the group of data that you would like split
- Then go to the Data tab on the Ribbon and in the Data Tools group you will find the Text to Columns option
- This will open up a window where you can complete a wizard that will help you appropriately split your text
No comments:
Post a Comment