Search rowmedic

Remove DuplicatesFix Date FormatRepair CSVClean TextCSV ValidatorCSV to ExcelRemove Empty RowsClean Excel DataToolsUse CasesPricingBlogHelpWhich columns make a record unique?Read a broken CSV one record at a timeStandardize dates without swapping the month and day
rowmedic
← All tools

Clean Text

Extra spaces can keep two otherwise identical labels from matching in a lookup. Clean a specific column, compare the changes, and preserve punctuation or spacing that carries meaning.

Open Clean Text →

How to use this tool

  1. Choose a text column such as City or Department and inspect a few original values.
  2. Trim the ends, collapse repeated spaces, change case, or find and replace a specific string. Apply one change at a time when the column contains names or codes.
  3. Review the preview, including accented names and meaningful punctuation, then apply and export.

Worked examples

Original dataAfter review
“ North Office ”“North Office” after trimming
“Sales Operations”“Sales Operations” after collapsing spaces

Frequently asked questions

Does trimming remove spaces between words?

Trimming changes the start and end of each value. Use the repeated-space operation if you also want to collapse multiple spaces between words.

Should I title-case every customer name?

Review exceptions such as McKay, van der Meer, and company initials. Capitalization alone cannot tell you a person’s preferred spelling.

Try this tool with the customer demo →

Browse all tools · Import and export help