How to Remove extra Spaces from Cell data in Excel 2016

preview_player
Показать описание
Learn how to remove extra spaces or excess spaces from string of data in cells in excel 2016 - Office 365. Sometimes when you import data from a different system into Excel the data might contain some extra spaces. You can use TRIM function to remove extra spaces and keep only one space between words in the data in cells.
Рекомендации по теме
Комментарии
Автор

it does not delete tab-spaces in text.

robryder