 Did you know you can take the text in one cell and separate it out across separate columns? Rod here. And today you're going to learn one of three ways to separating information in a cell. Videos showing the second and third ways are coming shortly. So subscribe to our channel and get these videos automatically. Let's say you're a plant manager. Congratulations! And at the end of the week you received this complete analysis of your inventory. As you can see in column B, you have the item description with the item number one through nine, the item type A, B, or C, and the item color. You want to know the inventory value of each item type and by each color. You could spend the time copying and pasting the inventory value of each item and color onto a separate worksheet and then summing the values. Or you could use Excel 2016 to easily split up the item description number type and color by converting this text into different columns. Here's how. We'll work with the items colored red and we have a definite advantage because every item description has the same format, the same length. We'll demonstrate the importance of this advantage in our next videos. Now first add the columns you need by pressing CTRL plus. We're going to do this three times to add three columns. Now select the cells that you want to split, then go to data, press text to columns. Now select fixed width and click next. Then check that arrows are in the correct space brick. Move the arrows if necessary. Select general format. Then choose the destination. In this case it's C3. Now click finish. As you can see the text has been converted meaning each part of the item description is split up into separate columns. So now you can easily select and sum the inventory values for the color red. This is time saving and amazing right? But what do you do if the text is linked by commas or dashes? What you do is follow the same exact process as before but this time you will select delimited. Then click next. Now you can select the delimiters which will define your bricks. For this exercise you will select a comma and a dash. You can see a preview of your data in the data preview window. Now select general format. Then choose the destination which in this case is C3. Now click finish. As you can see the columns are now converted into separate columns but without the commas and dashes. And now you can easily select and sum the inventory values for the color red. Imagine the time you will save using these steps in Excel 2016 when working with huge massively long inventory lists or email addresses or membership lists. To practice these steps hit the button below and go to our practice program. If you liked this video please comment share it and hit the like button and please remember to subscribe to our channel. Also let your friends know that if they have an electronic device they too can burn to learn. Thanks for watching.