Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |