Removing Spaces on Google Sheet
How To Trim Whitespace In Your Data On Google Sheet
Sometimes when you add data to a google sheet, it may not be the format you need.
Now, you can easily keep your sheet standardized by using the trim whitespace feature to remove any leading, trailing, or excessive whitespace from a cell or array of data.
You can also use TRIM function to remove the whitespace too
To trim whitespaces follow these steps
1. Select a cell or range of data that contains whitespace on your sheet
From the toolbar,
2. Select Data, then Trim whitespace
You’ll then see a dialogue box that details how many cells whitespace was removed from.
Is the video helpful?
Follow Lead-Leap Consulting Limited and Akerele Oluwasogo, GLMP (MR EXCEL) for more educative and interactive videos on Google and Excel sheet
Join our Advanced Excel Data Analytics Masterclass
Call us on 08062468296 or visit www.leadleapconsult.com to register
Смотрите видео Removing Spaces on Google Sheet онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Akerele Oluwasogo (Mr Excel) 01 Январь 1970, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 92 раз и оно понравилось 1 людям.