Here are some problems that our users have asked and received explanations on
MY =RIGHT FORMULA TO REMOVE CHARACTERS IN EXCELL IS NOT WORKING
Solved by I. D. in 19 mins
The data in column C has nonprintable characters before and after the data contained in each cell. In cell G2, enter a formula to remove any nonprintable characters from column C. Copy the formula down the column.