Results 1 to 6 of 6

Code to shrink font size after the first 3 characters and spaces

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-30-2010
    Location
    Kansas, USA
    MS-Off Ver
    Excel 2010
    Posts
    100

    Code to shrink font size after the first 3 characters and spaces

    I'm looking for a way to quickly make the font size of a text string within a cell smaller than the first 3 characters. For Example:

    11 Smaller
    12 Smaller
    13 Smaller
    14 Smaller
    etc...

    The numbers I want the font size to be 11 for example and for the "Smaller" part I want the font size to be 9.

    I need to be able to do this for multiple cells quickly instead of manually going to each cell and highlighting the smaller part and changing the font size.

    Thanks in advance!
    Last edited by trickyricky; 03-26-2011 at 12:45 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1