HI All,

How do I pad an expression with spaces or characters to a specified length on the left or right sides, or both In VBA?

Ex : X = ‘ 25 ‘ (my expression)

What I need to do is to make
X = ‘00025’ using a function ( Just like Lpad() in Foxpro)

TIA

- Jeana -