Hi

Sorry for the confusing title.
I'm not too sure what this will be called, so struggled explaining it, let alone looking for it

I have a column with text in it. I need to set the length of each entry to say 16 chars, using only spaces after the word, to make up any missing.

There are several columns I need like this, which I will then export out to a flat txt file to feed into another program.

i.e.
"qwerty"
"supercool"
needs to be

"qwerty "
"supercool "

Any ideas?

i have tried a few basic ideas, but when you copy them across you loose the spacing