myString = Left(myString & Space(12), 12)

"santaviga" skrev i meddelelsen
...
Hi to all.

I need some help with exporting excel data to text file, I have data in
cells, I have a code for only returning max of 12 characters, this is fine
and working, but the cells that have below 12 characters I need these
cells
to padded out with spaces so that when I export to a text file it looks
like
columns in the text file.

Can anyone help me with this

Regards