Swab th' Spaces

Remove leadin', trailin', an' repeated spaces from text cells.

Drop or select an Excel scroll t' swab spacesMax 5 MB per scroll

How it works

Hidden spaces cause failed lookups, broken VLOOKUPs, an' sortin' troubles. Trim them all in seconds instead o' fixin' cells one by one.

Does it remove spaces inside text too?

By default it trims leadin' an' trailin' spaces. Ye can optionally collapse repeated internal spaces.

Can I swab only specific columns?

Aye. Ye can select specific columns t' swab or leave it on all columns.

Will it affect numbers or dates?

Nay. Only text cells arr trimmed. Numbers an' dates remain unchanged.

Normalize text t' upper, lower, or title case.

Bulk find an' replace text or regex patterns across sheets.

Find an' remove duplicate rows based on selected columns.