Hi all,
How do I find the pixel length of a string, so that I can find if it can be accommodated into a cell with a fixed length.
I could find a similar post in the forum https://www.excelforum.com/showthread.php?t=530800. But it was not answered
rgds
johnjohns
The default width of a cell is 8.43 characters. You can find the number of characters in a text string using the LEN() function. But, the number of characters you actually get in a cell without wrapping depends on the font and size you choose. Kerning also impacts since the letter "i" is not as wide as "H", etc.
Maybe you should explain what you are trying to accomplish with such a calculation.
Ben Van Johnson
Using a fixed width font would be a good start.
Remember what the dormouse said
Feed your head
Hello johnjohns,
This UDF macro should help. The pixel size is dependent on the font size. If macro uses the default setting for your Excel application. You may want to use the cell 's font setting instead.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thankyou ProtonLeah, Romperstomper, Leith Ross,
I am afraid if I have not put my request clear enough. My intention is to split a sentence into many rows for better readability. For the words in cell B7, first 38 characters ("Up to 3 Citi Miles for every US Dollar") can fully fit into the width of column B. So I should be able to avoid the lineand take LettersPerLine as 38. And that will be my average number of characters per line. I am avoiding text wrapping. Can this be done?Please Login or Register to view this content.
best regards
johnjohns
Did you look at cellproperties/wordwrap ?
I did not get you fully, snb. Can you please provide the code?
rgds
johnjohns
You don't need code.
Select the cell, mouse rightclick / cellproperties / tab 'alignment' / wordwrap
Hi snb
I am using Excel 2003 and 2007. If it is 'Format Cells -> Alignment -> Wrap Text' , then that is not the requirement. I want the splitting to come in different rows. I think if you see the attachment it would be more clear.
rgds
johnjohns
One weird way of doing it is
But that is too weird an approach. Any better ideas?Please Login or Register to view this content.
rgds
johnjohns
If you set the Normal font to a fixed width font, then a column width of 38 will fit 38 letters, regardless of what they are. This then simplifies your task of breaking up the text.
Hmm....it seems there are no better ways to do this other than what you all advised. I did a google search also. Thank you all
rgds
johnjohns
You can use Word to do the trick:
Please Login or Register to view this content.
Last edited by snb; 01-18-2011 at 10:07 AM.
thanks snb. i will try and come back. it is time to leave the office
rgds
johnjohns
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks