Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
Format changes from "General" to "Text" | Excel Discussion (Misc queries) | |||
how do I format some text....."abc123" into "abc 123" | Excel Discussion (Misc queries) | |||
Excel VBA to convert "dd.MM.yy" text to "dd/MM/yyyy" format date? | Excel Programming | |||
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) |