G Guest May 27, 2004 #1 Can text be formatted as "small caps" in Excel? Can't find info, and when I try to copy something from Word the formatting is dropped.
Can text be formatted as "small caps" in Excel? Can't find info, and when I try to copy something from Word the formatting is dropped.
F Frank Kabel May 27, 2004 #2 Hi not available in Excel as format -- Regards Frank Kabel Frankfurt, Germany tomi said: Can text be formatted as "small caps" in Excel? Can't find info, and Click to expand... when I try to copy something from Word the formatting is dropped.
Hi not available in Excel as format -- Regards Frank Kabel Frankfurt, Germany tomi said: Can text be formatted as "small caps" in Excel? Can't find info, and Click to expand... when I try to copy something from Word the formatting is dropped.
D Dave Peterson May 28, 2004 #3 Pat Finegan wrote a macro that changes the size of the font for the small caps to 85% the height of the large caps. http://groups.google.com/[email protected] But you can only do this type formatting against real text--not the results of a formula.
Pat Finegan wrote a macro that changes the size of the font for the small caps to 85% the height of the large caps. http://groups.google.com/[email protected] But you can only do this type formatting against real text--not the results of a formula.
G Guest May 28, 2004 #4 I'm not familiar with 'small caps' but if you mean lower case use the function =LOWER( Input the cell reference into the parentheses
I'm not familiar with 'small caps' but if you mean lower case use the function =LOWER( Input the cell reference into the parentheses
D Dave Peterson May 29, 2004 #5 If you open MSWord and type: =rand() and hit enter, you'll see a bunch of text magically appear. Highlight the paragraph and hit Format|Font... There's a checkbox for small caps. (each character is uppercase, but the ones that should be lower case a touch smaller.) === inside word, =rand(3,5) will make 3 paragraphs each with 5 sentences. You do have to have: Tools|Autocorrect options|autocorrect tab|Replace text as you type turned on for this to work.
If you open MSWord and type: =rand() and hit enter, you'll see a bunch of text magically appear. Highlight the paragraph and hit Format|Font... There's a checkbox for small caps. (each character is uppercase, but the ones that should be lower case a touch smaller.) === inside word, =rand(3,5) will make 3 paragraphs each with 5 sentences. You do have to have: Tools|Autocorrect options|autocorrect tab|Replace text as you type turned on for this to work.
