Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
Repost: How to calc string's printable width?
Hi,
Task at hand is to achieve this effect to print a directory: Short Company Name....................Meredith Rockefeller Long Company Name Truncated If Nece.......Judy Short What we have here is left/right justified concatenation of: LEFT(CompanyName,x) & "...y.dots..." & Contact So we seek a solution to figure out x and y. Maybe some library offers such facility? AutoFill certainly manages to work out the widths 1 by 1 but can this be bettered? TIA, Paul PS. Task gets urgent so forgive the crosspost :) |
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
Repost: How to calc string's printable width?
Hi Paul,
Task at hand is to achieve this effect to print a directory: Short Company Name....................Meredith Rockefeller Long Company Name Truncated If Nece.......Judy Short What we have here is left/right justified concatenation of: LEFT(CompanyName,x) & "...y.dots..." & Contact So we seek a solution to figure out x and y. Maybe some library offers such facility? AutoFill certainly manages to work out the widths 1 by 1 but can this be bettered? One possibility is to use a text box on the sheet set to AutoSize and not word wrap, put each half of your text in it, then read the width. However, when you come to print the sheet, the printer font substitution will probably misalign the right-hand sides anyway. It might be better to use Word instead, where you can set a flush-right tab stop. Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.co.uk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Cell Width WITHOUT changing Column width | Excel Discussion (Misc queries) | |||
Calc = Manual & Do Not Calc b/4 SAVE | Excel Discussion (Misc queries) | |||
ASC() does not convert full-width to half-width letters (Exel 2003 | Excel Worksheet Functions | |||
auto calc on, but have to edit (f2) cells to force re-calc..help! | Excel Worksheet Functions | |||
How to calculate cell's contents printable width? | Excel Programming |