| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Multiple alignments
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automated multiple text files into multiple sheets in one workbook | Excel Discussion (Misc queries) | |||
| how to make a macro to clear multiple cells from multiple worksheets? | Excel Worksheet Functions | |||
| Delete Blank Rows Code - Multiple Worksheets - Multiple Documents | Excel Discussion (Misc queries) | |||
| view multiple files in multiple windows on multiple screens. | Excel Discussion (Misc queries) | |||
| Cell Alignments using a reference worksheet | Excel Programming | |||
Linear Mode
