| 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 |
| Reply |
| 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) | |||
Linear Mode
