Editing spreadsheet is fast and straightforward using DocHub. Skip installing software to your laptop or computer and make changes using our drag and drop document editor in just a few easy steps. DocHub is more than just a PDF editor. Users praise it for its ease of use and robust capabilities that you can use on desktop and mobile devices. You can annotate documents, make fillable forms, use eSignatures, and deliver documents for completion to other people. All of this, combined with a competing cost, makes DocHub the perfect choice to undo spot in spreadsheet files effortlessly.
Make your next tasks even easier by converting your documents into reusable web templates. Don't worry about the security of your data, as we securely store them in the DocHub cloud.
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