Many people find the process to erase stuff in WPS rather daunting, particularly if they don't frequently deal with documents. However, nowadays, you no longer have to suffer through long tutorials or spend hours waiting for the editing app to install. DocHub allows you to adjust forms on their web browser without installing new programs. What's more, our feature-rich service provides a complete set of tools for professional document management, unlike so many other online solutions. That’s right. You no longer have to donwload and re-upload your forms so often - you can do it all in one go!
Whatever type of document you need to modify, the process is easy. Take advantage of our professional online solution with DocHub!
you can remove extra spaces between words with find and replace leading and trailing spaces will also be trimmed to one but will not be completely removed we have a few names in column a that have some space between and after the text as well as more than one space between the words in column b let us use the len function to count the number of characters select the cells from which you want to remove extra spaces then go to the home tab in editing section press the find and select button choose the replace option from the menu in the find want section add two space characters press the spacebar twice on the keyboard in the replace with section add a single space character click on options button for more advanced find and replace options make sure the within sheet and looking form loss are selected click on the replace all button press the replace all button a few times until it can no longer find any double spaced characters in the data this will leave a single space in between words