From: Tonso on 3 Apr 2010 14:00 is there a convenient way in xl2003 to line items up left aligned and right aligned in a drop down list. example red roses 1 white roses 10 purple pansies 275 the names are left aligned, and the numbers are right aligned. i can create the list, and tinker with it by adding/deleting spaces until they are aligned in the dropdown list, but i was wondering if ther was a better way, as the list is very long. thank you, Tonso
From: Tonso on 3 Apr 2010 14:13 On Apr 3, 2:00 pm, Tonso <wthoma...(a)hotmail.com> wrote: > is there a convenient way in xl2003 to line items up left aligned and > right aligned in a drop down list. > example > > red roses 1 > white roses 10 > > > the names are left aligned, and the numbers are right aligned. > > i can create the list, and tinker with it by adding/deleting spaces > until they are aligned in the dropdown list, but i was wondering if > ther was a better way, as the list is very long. > > thank you, > > Tonso another question regarding this list. the numbers to the right can be from 1 to 3 digits long. I would like to be able to muliply the numbers in cass of multiple requirments. for example: purple pansies 275*2 in this case the result, 550, would show up in another cell. or, even if there were no multiplication, the number 275 would show up in the cell. as i stated b4, the digits in the multiplicand can be 13 digits ling, and the same for the multiplier. i had envisioned being able to press f2, then typing in " *2 ", then enter, and the resulting multiplication show up in the another cell.
From: Don Guillett on 3 Apr 2010 16:16 Why not RE think your design and have the item in one column and use a vlookup formula tied to the drop down?  Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Tonso" <wthomasss(a)hotmail.com> wrote in message news:ea022a1bc42c4b87aa469aaa45b88508(a)l25g2000yqd.googlegroups.com... On Apr 3, 2:00�pm, Tonso <wthoma...(a)hotmail.com> wrote: > is there a convenient way in xl2003 to line items up left aligned and > right aligned in a drop down list. > example > > red roses � � � � � � � � �1 > white roses � � � � � � 10 > > > the names are left aligned, and the numbers are right aligned. > > i can create the list, and tinker with it by adding/deleting spaces > until they are aligned in the dropdown list, but i was wondering if > ther was a better way, as the list is very long. > > thank you, > > Tonso another question regarding this list. the numbers to the right can be from 1 to 3 digits long. I would like to be able to muliply the numbers in cass of multiple requirments. for example: purple pansies 275*2 in this case the result, 550, would show up in another cell. or, even if there were no multiplication, the number 275 would show up in the cell. as i stated b4, the digits in the multiplicand can be 13 digits ling, and the same for the multiplier. i had envisioned being able to press f2, then typing in " *2 ", then enter, and the resulting multiplication show up in the another cell.
From: T. Valko on 4 Apr 2010 22:15 Just for the heck of it... I see in your followup post you want some different stuff so you may not want to do this data alignment afterall, but if you do... A1:A3 = red roses white roses purple pansies B1:B3 = 1 10 275 The numbers in B1:B3 will be from 1 to a max of 3 digits. To concatenate those cells and align the data... First, you'll have to use a fixed width font. Maybe Courier New. Then, you have to know how many spaces between the data you want as a default. Let's assume you want a default of 3. This means every concatenated cell will have at least 3 spaces separating the data. Enter this formula in D1 (all on one line): =A1&REPT(" ",MAX(INDEX(LEN(A$1:A$3),0)) LEN(A1)+3+(3LEN(B1)))&B1 Format to use the Courier New font. Copy down to D3.  Biff Microsoft Excel MVP "Tonso" <wthomasss(a)hotmail.com> wrote in message news:c5afddc41e7a49d9a771f437e499c5d3(a)r1g2000yqj.googlegroups.com... > is there a convenient way in xl2003 to line items up left aligned and > right aligned in a drop down list. > example > > red roses 1 > white roses 10 > purple pansies 275 > > the names are left aligned, and the numbers are right aligned. > > i can create the list, and tinker with it by adding/deleting spaces > until they are aligned in the dropdown list, but i was wondering if > ther was a better way, as the list is very long. > > > > thank you, > > Tonso

Pages: 1 Prev: How to enter excel dates for last year? Next: sorting two columns of merged cells 