Place your cursor on cell C5 and type the following function: =TRIM(A5) The above function will remove all unwanted spaces from the text string in cell A5 and display the result in cell C5. To ...