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 :) |
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 |