View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
MD MD is offline
external usenet poster
 
Posts: 10
Default Multiple alignments

thank you


"Nigel" a écrit dans le message de news:
...
AFAIK you cannot do this. You could separate the two parts and fill the
intervening with appropriate number of spaces but then you run up against
proportional fonts having varying character widths. Also if you change
the
column width you would need to recompute based on the new width.

I would recommend using two columns, appropriately spaced and formatted.

--
Cheers
Nigel



"MD" wrote in message
.. .
Hello,

Id like to know how to do a multiple alignment in 1 cell. I have in cell

A1
"Apples: 23kg", and I want "Apples to be aligned left and "23kg" to be
aligned right but all in cell A1.

thx

Michel