Clean up data in cells: Quickly remove duplicate data, and trim white space in your sheet

Home Forums Google Sheets & Forms Clean up data in cells: Quickly remove duplicate data, and trim white space in your sheet

Viewing 0 reply threads
  • Author
    Posts
    • #5922
      AvatarRob Clarke
      Keymaster

      Remove duplicates:

      Have you just imported a batch of data into your sheet only to find it is full of duplicate information? You can use this tool to easily remove duplicate values.

      Sheets - remove duplicates

      Here’s how:

      1. Select the range of data you wish to clean up.
      2. Go to Data Menu > Remove Duplicates.
      3. This brings up a menu where you can customise your selection if you wish.
      4. Click the Green Remove Duplicate button.
      5. Bingo! All cells in your selection with duplicate data will be removed.

      Trim White Space in copy:

      Sometimes when you add or import data into a sheet, it may not be formatted the way you would like.

      Now, you can easily clean up the copy by using the trim whitespace feature to remove any leading, trailing, or excessive whitespace from the text in a cell or array of data.

       

      Attachments:
      You must be logged in to view attached files.
Viewing 0 reply threads
  • You must be logged in to reply to this topic.
Skip to toolbar