I would like to find Macro or Function that will make text size to suite
text Length?

eg. if the first cell has "bill smith" then the text size would be 10.
But if you had "Christina Vandermear" then the text size would be as small
as 7 in order to fit in that same size cell.

I know it's a bit of an odd request, but is there a way to do that? thanks