Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi all,
In cell A2 is a name, say Johnson. In cell B2 a code, say Ab89-w-5 In cell K2 is a date (in European notation) say 16 september 2009 All in Tmes New Roman 10. Ik want in cell Q2 this Johnson Ab89-w-5 16 september 2009 So - on different lines - the name left aligned en both other data right aligned (if possible) Also if possible I would like the name in Times New Roman 10 and in bold, and the rest in Arial 7 (not bold). I spent a lot of time on it but I can't figure out what code to use and I wonder if it is possible at all. If all is not possible it would be next best if I got the three data below each other in one cell with Johnson in bold type. If that also is not possible I will work with the three data below each other. I use Excel 2000 (9.0.6926 SP-3) Your advice will be highly appreciated. Jack Sons The Netherlands |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combining Cells | Excel Discussion (Misc queries) | |||
Need help with combining cells to one | Excel Discussion (Misc queries) | |||
Combining and merging lines | Excel Discussion (Misc queries) | |||
combining 3D with lines | Charts and Charting in Excel | |||
combining cells | Excel Discussion (Misc queries) |