Hello everyone
In column F I have some data and the data in each cell is in two parts ..
In the yellow cells the data are adjusted to look in neat format ..
How can the spaces adjusted between the two parts to be like the yellow cells?
Thanks advanced for help
* The thread is posted at this link too
http://www.eileenslounge.com/viewtopic.php?f=30&t=31478
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Hello YasserKhalil,
See if this Post is of any help.
Regards.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Thanks a lot Winon .. I have looked at the post but I don't know how to make use of that
The trick point I think is how to calculate the column width and detect the number of characters that may be used ..
I don't think even that will give you the neat result you're looking without using a monospaced font such as 'Courier' to line everything up.Originally Posted by YasserKhalil
You could easily write a sub that would loop through and adjust the number of spaces between the two sections of text in each cell and add enough spaces to normalise the layout, but you would need that font change for it to look right. Happy to help with that if you'd like.
OR, you could simply split the column into two columns and do it that way...
BSB
Thanks a lot for reply .. I don't prefer to split the column
And I will glad of your help as for the first approach
Thank you very much
This is my try till now but I got incorrect output
Please Login or Register to view this content.
Maybe something like this?
BSBPlease Login or Register to view this content.
Thank you very much for this perfect solution
So it is limited to this type of font .. we can't adjust it with the same font type 'Arial'?
Hi Yasser,
a little help from me see its sutaible for you or not.
Please Login or Register to view this content.
Regards,
MohanS
"Perfection is not attainable, but if we chase perfection we can catch excellence." - Vince Lombardi
You can simply say thanks by clicking "*Add Reputation" icon
You might be able to but would be difficult to get perfectly lined up every time.
Not sure I'd want to sit and write that code as the benefit wouldn't be worth the effort I feel.
BSB
Thank you very much for replies
I think the solution in post #7 is the most suitable
Best Regards
This will worked for non monospace font too.
This is my gift for you, Merry ChristmasPlease Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
Dear Khalil
Hope your fine.
You can write this formula in Column I and paste to column F
Formula:
Please Login or Register to view this content.
Capture7.JPG
Thanks
Ahmed
Thanks a lot Ahmed
Thanks a lot the Legend Man and thanks a lot for this awesome gift
Best Regards
You are welcome, hope this can help.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks