Deleting whitespace in Excel 97 Macro 1

[modorney]

I need to delete whitespace in Excel 97
What I have is a bunch of cells with data like " ABC"
and I want to do a macro that will trim them to "ABC"
They all have the same number of spaces, so all I want to do is
go to each cell and enter ^t and have the macro remove a fixed number of
blank spaces.

TIA
mike [sig][/sig]

 

[Dreamboat]

Might be easier to do a find/replace?

Just hit ctrl-h. In the find box, enter the number of spaces you're trying to remove (hit your space bar X number of times). In the replace with box, don't put anything! Hit replace all.

You can easily record that macro. [sig]<p> <br><a href=mailto:techsupportgirl@home.com>techsupportgirl@home.com</a><br><a href=

http://www.wedomanuals.com>

</a><br> [/sig]

 

[modorney]

This worked great!
Thanks, Dreamboat!

-- mike [sig][/sig]