Checkout the Step-by-Step Tutorial here:
[ Ссылка ]
In most data sets you may need to break up the text into many columns of data. In my example below, I will show you how to do this on text that has various lengths, so the formulas can be tricky but there is an easy way to do this using the Excel Text to Columns feature. Also, if you visit my blog, you will have a detailed tutorial on with formulas so that you can break up text to many columns for a typical Address.
