Text format in "Concatenate" function

[Rita Palazzi]

MS Office Professional 2006
Windows XP Professional


I have a concatenate statement that includes a line break (char(10)). I
would like to resize the text only on the second line of the results.
Is it possible to format text inside of a function?

My statement is below:
=CONCATENATE(TEXT('Import Chart Data Sheet'!B1,"mmm-yy"),CHAR(10),"
(",VLOOKUP('Import Chart Data Sheet'!B1,'Sort Days'!A1:B2867,2,FALSE),"
Sort Days)")


I'd like everything from the "char(10)" statement on to be a smaller or
predefined size.


Any suggestions/help is greatly appreciated!



Rita Palazzi
Project Engineer
International Planning and Engineering
FedEx Express

 

[Rita Palazzi]

Thanks, I just ended up splitting the results into two different
cells... Appreciate your response!