Hi! You are watching Financial Modeling in Excel, brought to you by 365Careers. 2 2
This video is dedicated to Excel's Text to Columns tool. 3 3
It is quite useful in situations, when you have a large amount of text within single cells of your spreadsheet. 4 4
Practitioners often have to copy raw data from a PDF file, and the data from each row goes in one cell. In this sheet we have data in a few 5 5
rows, which is in the same cell and is neither understandable nor usable. 6 6
In order to organize such data, we have to use Text to Columns. 7 7
I'll go in the data menu and click the Text to Columns box. 8 8
in this dialog box, Excel provides us two choices. We have to decide, which will be the criteria that 9 9
will indicate how to separate the data in columns. 10 10
"Delimited width" is suitable when the data within the cell is separated by a blank space, 11 11
comma, dot or something else. "Fixed width", on the other hand, is the mechanical way to divide the data in 12 12
columns. In our case it seems that "delimited width" should work. 13 13
Very often you have to try a few times in order to find the right way to separate the data into columns. 14 14
In this dialog box, we need to choose the criterion, which will be used in order to separate the data into columns. 15 15
I'll check the box space and here 16 16
we have a preview of what will be the output of our modification 17 17
I think it looks good and that's why I'll click "Finish", 18 18
in order to complete the command. 19 19
OK. Here it is. Our data is nicely organized into columns. This is how we use "Text to Columns". Thank you for watching!