You can use a formula like:
=A1 & REPT(" ",20-LEN(A1))
In an different column.

Hope this helps,
Miguel

"Tat" wrote:

Hi,

I have a barcode label requirement that wants the field to be 20 characters
long and right justified with unused positions populated with blanks. There
is no additional info on whether the blanks should be leading or trailing the
numbers. If I want to make them trailing, what formula would I use to do
this? I have started with "=Space(20)- LEN" to count the length of my actual
number string but the output does not look correct. Any suggestions would be
greatly appreciated.
--
Thanks and have a wonderful day.
Tat