text formating

[tomi]

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.

 

[Frank Kabel]

Hi
not available in Excel as format

--
Regards
Frank Kabel
Frankfurt, Germany

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.

 

[Dave Peterson]

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.

 

[Compu Geek]

I'm not familiar with 'small caps' but if you mean lower case use the function
=LOWER(
Input the cell reference into the parentheses

 

[Dave Peterson]

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.