Custom formula to change to small caps

**rasherb** · 05-21-2009, 04:40 PM

I've seen macros for this but I need a formula that pulls from a different worksheet.
Can someone help please?

Here's what I've got so far:

Please Login or Register  to view this content.

**shg** · 05-21-2009, 04:50 PM

A string doesn't have a font size. You need to do it after the data is copied.

Please Login or Register  to view this content.

**rasherb** · 05-22-2009, 11:09 AM

Okay. Thanks!

I want to make a formula though.

So I can type text into one cell and the formula will pull the text and format small caps into another cell.

Any ideas for making this a formula, rather than a macro?

**shg** · 05-22-2009, 11:17 AM

It can't be done with a formula for the reason I explained in the first post -- string variables don't have fonts, they are just strings of characters. A cell can contain rich text, so you can format individual characters with varying font, font size, bold, italic ...