Convert your data into an Excel tableSolution 2: Use the TRIMRANGE functionSolution 3: Use the trim ref operatorWhole-column ...