Got it working with the macro. Tried the =MID(A1,3,255) but didn't
work for me as needed.

Thanks to all,
Tom


On Jan 29, 2:33 pm, "T. Valko" wrote:
Here's a link to a nice little macro that's perfect for this:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Biff

"Tom" wrote in ooglegroups.com...



Hello,

When importing external data into excel, I end up with 2 blank spaces
before the data. Need to remove the 2 blanks spaces for all the cells
in that column. Changed the format and tried decreasing indent,
neither worked.

Is there a formula or VBA code that would work?

Thanks,
Tom- Hide quoted text -- Show quoted text -