My mantra when teaching is ‘if you are doing it the long hard way, you are doing it the long hard way.’ Here’s a way to make it easier to split up data into different fields. You can use the LEFT or RIGHT functions, but there’s an even easier way. Continue reading “Text to Columns–The short easy way”