Need to change the data in a cell from lots of characters to just a few?

My students come to me with all sorts of questions. One that seems to come up every so often is how to easily change the length of a piece of data in a cell to just a few characters and then do the same throughout the entire column which sometimes could reach thousands of rows. … Continue reading Need to change the data in a cell from lots of characters to just a few?