Hi,

I am trying to find how to remove the padding or space from a string.

I have imported data and when I use vba to manipulate the string there appears to be loads of padding on the end of the data?

ie:

"Mr A Customer "

instead of:

"Mr A Customer"

I cannot find anything regarding how to remove remove it, is it called padding????

Thanks

Darrell....

Use the Trim function.

............