Remove empty spaces at the end of string

[tamnet]

HI,
I have inherited a workbook that imports data from a text file via a macro and the problem i have is that although the text in the columns reads OK it appears that empty spaces are imported. i.e the first column contains customer names and despite the length of the name the column is always 30 characters wide, i have various other columns that are the same where these hold the address of the customer.

Could someone give me a way to remove all these empty spaces from my columns please using VBA code, it would be much appreciated


Regards

Paul

 

[tamnet]

It's OK I have found a solution from the following thread

thread707-507216

Thanks to Zanthras


Regards

Paul