| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining a string of text
I want to combine a string of text from several cells. I can do this however
the format of the text needs to be different. Example. I have "New Loan Application" in cell A1 and it is in Calisto MT size 9 font. In cell B1 I have "to be submited in" also in Calisto MT size 9 font. Then in cell C1 i have the number "5" in Arial, Bold, underlined and in size 10 font. Then I have "business days" in cell D1. I want to combine all 4 cells into one cell with all of their respective font sizes, styles and characteristics. ie bold, underlined, or italicized. I have been playing around with: =A1&B1&C1&D1 but can't get the right fonts and styles. Is there a way to make this happen? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced text function (combining text) | Excel Worksheet Functions | |||
| Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
| Sumif text is contained winthin a longer text string in a cell | Excel Worksheet Functions | |||
| combining text and numbers in a string | Excel Worksheet Functions | |||
| Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
Threaded Mode
