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
Watch video Removing Spaces on Google Sheet online without registration, duration hours minute second in high quality. This video was added by user Akerele Oluwasogo (Mr Excel) 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 92 once and liked it 1 people.