View Single Post
 
Old 09-20-2019, 07:10 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

Don't think what you're after is possible using a non-proportional font like Calibri because width is based on the characters used not the character count.
an example with same number of characters:
GALA - XX, XXXXXX INDUSTRIAL PARK, PLOT XXX/1, XXXXXX MIDC, XXXX MUMBAI - XXXX05.
GALA - II, IIIIII INDUSTRIAL PARK, PLOT III/1, IIIIII MIDC, IIII MUMBAI - IIII05.

Are you interested in a macro solution using a fixed width font like "Courier New" ?
same examples:
GALA - XX, XXXXXX INDUSTRIAL PARK, PLOT XXX/1, XXXXXX MIDC, XXXX MUMBAI - XXXX05.
GALA - II, IIIIII INDUSTRIAL PARK, PLOT III/1, IIIIII MIDC, IIII MUMBAI - IIII05.


also, is the period and space at the end of the address really necessary ?
Reply With Quote