Go to a blank cell, and type =CLEAN(CELL) where CELL is the location of your text. Copy the new cell, and paste as values in the old cell location (right-click, paste special, click the values radio button).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.
