Useful Hacks, Reviews, Tips and Tricks of anything under the moon and the sun.

Trim spaces in MS Excel using Add-In

No comments
This morning, I was trying to import data from a delimited text file into excel. Some data imported contains ugly trailing spaces on it. Instead of tediously remove those spaces manually, I used a MS Excel Add-In called Trim spaces.

The Trim Spaces add-in can help you remove leading and trailing spaces in selected cells. To remove these spaces using the Add-In, follow these steps.

1. Select the cell(s) you want to remove leading and trailing spaces.
2. Run the Add-In by going to Excel Menu -> Trim Spaces for Excel.

Trim spaces in MS Excel using Add-In

3. On the Trim Spaces dialog box, click Run button to automatically remove those spaces.

Trim spaces results

Download Trailing Space via ablebits

No comments :

Post a Comment