M
Matt
I know to find the Length of a string, you can use the LEN() formula.
Is there a way to calculate the Width of a string in pixels or some
other units of measurement?
For example, look at these five letter words below, they all have the
same number of letters, but because some letters are wider than
others, the total width of the word on the screen/page is wider.
Like, the capital letter W is wider than the capital letter I.
SILLY
FILES
INDEX
PRICE
WHITE
BUNNY
HARSH
RANGE
HORSE
AGGRO
WHALE
(you can see, depending on the font you're viewing this list in, that
the words at the top of this list are slightly shorter in pixel or em
width, and the words at the bottom are wider. if my phrase/string
contains multiple wider characters, it throws me over limit)
My end result requires me to print all-caps text on a small tag, and I
thought the LEN of 36 was the limit, but it actually depends on the
width of each letter and if the phrase has too many wider letters, it
runs off the page, regardless if it is less than 36 characters or not.
From what I hear, I'm looking for the "Em" measurement?
http://en.wikipedia.org/wiki/Em_(typography)
Any ideas?
Is there a way to calculate the Width of a string in pixels or some
other units of measurement?
For example, look at these five letter words below, they all have the
same number of letters, but because some letters are wider than
others, the total width of the word on the screen/page is wider.
Like, the capital letter W is wider than the capital letter I.
SILLY
FILES
INDEX
PRICE
WHITE
BUNNY
HARSH
RANGE
HORSE
AGGRO
WHALE
(you can see, depending on the font you're viewing this list in, that
the words at the top of this list are slightly shorter in pixel or em
width, and the words at the bottom are wider. if my phrase/string
contains multiple wider characters, it throws me over limit)
My end result requires me to print all-caps text on a small tag, and I
thought the LEN of 36 was the limit, but it actually depends on the
width of each letter and if the phrase has too many wider letters, it
runs off the page, regardless if it is less than 36 characters or not.
From what I hear, I'm looking for the "Em" measurement?
http://en.wikipedia.org/wiki/Em_(typography)
Any ideas?