Editing csv is fast and simple using DocHub. Skip downloading software to your laptop or computer and make adjustments with our drag and drop document editor in just a few quick steps. DocHub is more than just a PDF editor. Users praise it for its convenience and robust capabilities that you can use on desktop and mobile devices. You can annotate documents, generate fillable forms, use eSignatures, and deliver records for completion to other people. All of this, put together with a competing cost, makes DocHub the ideal decision to adjust space in csv files effortlessly.
Make your next tasks even easier by converting your documents into reusable templates. Don't worry about the protection of your information, 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
