Tag Archives: Text to columns

Text to columns: saving your file layout

The Text to columns function in Excel is useful. If you have a bunch of data in a single column, it can be used to split it into separate columns. Found on the Data ribbon,¬†you can either specify delimiters (for … Continue reading

Frequency count on a range of data

Challenge: I have thousands of rows of data, each containing multiple columns of piece of information. I want a frequency count of each piece of information that appears. I received some data the other day. In total, there were 1,000 … Continue reading