Formula Help

T

Tat

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

Miguel Zapico

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

Hope this helps,
Miguel
 
T

Tat

Thanks for the suggestion Miguel.
My issue is outside of Excel though. The program uses formulas such as you
create in Expression Builder in an Excel macro or Access.
 
Top