Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-20-2019, 07:10 AM
NoSparks NoSparks is offline Alignment of sentences Windows 7 64bit Alignment of sentences 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
  #2  
Old 09-20-2019, 09:33 PM
aditya@office aditya@office is offline Alignment of sentences Windows 10 Alignment of sentences Office 2010
Novice
Alignment of sentences
 
Join Date: Feb 2019
Posts: 8
aditya@office is on a distinguished road
Default

what about the vertical alignment of the sentences?

the letter 'G' from word GALA and letter 'C' from the word contact must coincide.
and same with the right side that below no. 5 from pin code the last letter of GST no. must coincide.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Alignment of sentences Macro to number sentences tjf816 Word VBA 10 03-29-2017 05:42 PM
Alignment of sentences How to find an identical sentences? Bill K Word 1 12-03-2015 12:16 AM
Alignment of sentences Comparing two sentences in two different columns JoAndRoPo Excel 5 08-07-2014 07:44 AM
Alignment of sentences keep only sentences beginning with: Wind Michael007 Word VBA 3 01-17-2011 04:11 PM
capitalize first letter of sentences norco1 Word 0 06-25-2006 12:37 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:43 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft