Text format in "Concatenate" function
 

Formulas (and real numbers) can't have this character by character formatting.

Rita Palazzi wrote:

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

--

Dave Peterson