Clean up data: split, Flash Fill, duplicates and validation

Updated November 13, 2026

Split text into columns

  1. Select the column and choose Data › Text to columns.
  2. Pick Delimited (split at commas, spaces or another character) or Fixed width, then follow the steps.

Flash Fill

  • Type what you want for one or two rows next to your data, such as first names taken from full names. Then choose Data › Flash fill (Ctrl+E).

Remove duplicates

  1. Select the data and choose Data › Remove duplicates.
  2. Tick the columns that make a row a duplicate, then choose OK. Cloud Sheets says how many rows it removed.

Limit what can be typed

  1. Select cells and choose Data › Validation.
  2. Under Allow, pick Whole number, Decimal, List, Date, Time, Text length or Custom, and set the limits.
  3. Add an input message and an error alert if you like, then choose OK.
  4. Data › Circle invalid circles cells that break their rule.

A List can show its choices as coloured chips. See Checkboxes and status chips.

Was this article helpful?