Use smart cleanup in Google Sheets
Use Data cleanup or direct cell edits to standardize the duplicate-looking customer and region values. Make A3 exactly Acme Ltd, B3 exactly North, A5 exactly Nova Inc, and B5 exactly South. Do not change rows 1, 2, or 4.
Verified by JosephineAbout 60 secondsUse Data cleanup or direct cell edits to standardize the duplicate-looking customer and region values. Make A3 exactly Acme Ltd, B3 exactly North, A5 exactly Nova Inc, and B5 exactly South. Do not change rows 1, 2, or 4.
Step-by-step
Select the targetUse Data cleanup or direct cell edits to standardize the duplicate-looking customer and region values.
Apply the changeMake A3 exactly Acme Ltd, B3 exactly North, A5 exactly Nova Inc, and B5 exactly South.
Shortcut or faster method
Select the full target range first. This avoids repeating the same change cell by cell.
Expected result
The inconsistent customer and region entries are cleaned to the same spelling, capitalization, and spacing.
Common mistake
Changing the source values while applying the formatting or structure change.
Troubleshooting
Re-select A3 and repeat the final action. The inconsistent customer and region entries are cleaned to the same spelling, capitalization, and spacing.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Customer | Region |
| Acme Ltd | North |
| ACME LTD | north |
| Nova Inc | South |
| nova inc | SOUTH |
Video transcript
- Open the prepared Cleanup review spreadsheet.
- Select the target. Use Data cleanup or direct cell edits to standardize the duplicate-looking customer and region values.
- Apply the change. Make A3 exactly Acme Ltd, B3 exactly North, A5 exactly Nova Inc, and B5 exactly South.
- The inconsistent customer and region entries are cleaned to the same spelling, capitalization, and spacing.