Remove Repeating Space

Delete consecutive spaces within a cell like "A and b.". Space represents an empty area or gap between characters or objects. Read more about space on Wikipedia https://en.wikipedia.org/wiki/Whitespace_character

The text "hello" with spaces is "h e l l o", because the space operation inserts a space character between each adjacent pair of characters in the text.

Improves the cleanliness and consistency of a text dataset.

• Microsoft Excel: SUBSTITUTE
• Google Sheets: SUBSTITUTE
• Apple Numbers: SUBSTITUTE
• Python Pandas: s.replace(' +', ' ', regex=True)
• Related Words: remove consecutive spaces, remove multiple spaces in a row