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