A copied spreadsheet row
- Text with tabs
- Name Age City
- Replace each tab with
- One space
Result Text without tabs: Name Age City
Tabs found: 2
Lines changed: 1
Length before: 13
Length after: 13
- Found 2 tab characters on 1 of 1 lines.
- Replaced every tab with a single space.
- Length went from 13 to 13 characters.
Cells pasted from a spreadsheet are separated by tabs; each becomes one space.