ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multiple alignments (https://www.excelbanter.com/excel-programming/326637-multiple-alignments.html)

MD

Multiple alignments
 
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



Nigel

Multiple alignments
 
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





MD

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








All times are GMT +1. The time now is 03:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com