For a certain period of time, when I need to split data in a column, my first choice is to use the Power Query add-in and the Split Columns option. However, there are still users who do not know how to use it, so I remembered that for this purpose we can also use the Excel option Text to Columns. In this “recipe” you will find out a practical way how to split one column into several.
How often do repeat certain words in the given text? Which one of them is most often repeated? The answer to this question can be obtained using a few simple techniques, which will be more talk in the text that follows. To begin with, a news post is taken from the link http://www.iib.rs/srl/bizit2018-srl/and we will analyse it to measure the frequency of words occurrence. The selected text should be copied to cell A1 of the new worksheet.
Although Excel is the best software to work with tables, we often create them in other software. Also, tables are commonly used for data exchange, when they are exported as tables in a text file as “Comma Separated Values”. In this file, each row of the table is a separate line in the text, and the values that are in the columns are separated by commas (hence the name). In the text that follows, we will show how to import text from one such file …