Padding in a String

[Darrell Wootton]

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....

 

[llkhoutx]

Use the Trim function.

 

[q582gmzhi]

Thanks for advise - No Msg

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