Formula Help
 

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

Formula Help
 

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

Formula Help
 

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.
--
Thanks and have a wonderful day.
Tat


"Miguel Zapico" wrote:

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