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: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
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