Tick it off to make sure no cells with formulas, dates, time, currencies and other non-text format is changed.Ĭlick the Remove button and see the characters you selected are erased from your spreadsheet. The last checkbox - Ignore non-text format and formulas - can be applied to any other setting within the group and is designed to avoid data corruption. ), opening or closing that you may have pulled from the web as well.ĭelete any line breaks, spaces, commas, and semicolons used as delimiters in your range in Google Sheets.Ĭheck this option to get rid of all non-breaking spaces, line breaks, and tabs in the range. Remove all HTML tags whether paired (e.g. This one will clear away all HTML entities like " " that appear in your data after importing them from web sources. If line breaks are also unwelcome in your data, this option will deal with them in all selected cells in one go. The add-on will delete all spaces in the selected range, including non-breaking ones. Ticking off this option will help you get rid of any extra blanks between words in the selected cells. Open the Remove spaces and delimiters group to see all the possible ways to delete excess blanks and delimiters in your sheet:Ĭheck the boxes next to the data you'd like to delete in the range of interest:Įliminate all extra spaces before and after the values in your cells that may impede with further calculations.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |