Remove Spaces

World s simplest whitespace tab and newline deleter.

Remove spaces. Add spaces after characters and or add spaces after every line and or add spaces after every enter your text here and click the remove button above. To get the length of a string use the len function. Text tools image tools and math tools.

If you like remove spaces please consider adding a link to this tool by copy paste the following code. Create a new empty column beside the column you want to remove spaces from in this example this new column starts with b2. Remove all spaces from cells.

This removes the spaces anywhere from the selected cells. Use the substitute function to remove all spaces or non breaking spaces. The len function counts 2 spaces 2 characters 4 spaces 3 characters and 2 spaces.

By another way we can remove the spaces by using a trim function. There we need to put a space and replace that with blank nothing kept. The trim function does not remove single spaces between words.

Click on the top empty cell in your new column b2. The first way we can remove the extra unwanted spaces with the help of find and replace option ctrl h. Type trim b2 and press enter.

Test by click the remove button and watch leading trailing extra all spaces disappear from each line of default text. The trim function below removes 2 leading spaces 3 extra spaces and 2 trailing spaces. If you want to get rid of all spaces in specific cells methods in this section can do you a favor.