![spacing between words in word 2009 spacing between words in word 2009](http://idata.over-blog.com/2/63/33/00//PDF-TO-WORD.png)
Where A2 is the cell you want to delete spaces from.Īs shown in the following screenshot, the Excel TRIM formula successfully eliminated all spaces before and after the text as well as consecutive spaces in the middle of a string.Īnd now, you only need to replace values in the original column with trimmed values. If your data set contains superfluous spaces, the Excel TRIM function can help you delete them all in one go - leading, trailing and multiple in-between spaces, except for a single space character between words.Ī regular TRIM formula is as simple as this:
#Spacing between words in word 2009 how to#
How to remove blank spaces in Excel - leading, trailing, between words Text Toolkit - quick way to trim spaces and clean data.Delete a specific non-printing character.Delete line breaks and non-printing characters.
![spacing between words in word 2009 spacing between words in word 2009](https://images.slideplayer.com/26/8283930/slides/slide_7.jpg)