| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
& to combine cells/Keep formats
Is there a way to combine cells similar to using the & symbol and keep
the formatting from the copied cell? If A1 = "Red" and it was bold and B2 = "Blue" and it was in blue font. Is there a way in C1 to =A1&B1 and keep the Bold formatting for red and the blue font for Blue? Thanks, Jay |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
& to combine cells/Keep formats
Sorry, that can not be done using formulas provided by Excel.
One has to use VBA to develop a function to this. "jlclyde" wrote: Is there a way to combine cells similar to using the & symbol and keep the formatting from the copied cell? If A1 = "Red" and it was bold and B2 = "Blue" and it was in blue font. Is there a way in C1 to =A1&B1 and keep the Bold formatting for red and the blue font for Blue? Thanks, Jay |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine cells with the same reference and combine quantities | Excel Discussion (Misc queries) | |||
| Combine Cells | Excel Discussion (Misc queries) | |||
| Combine Cells | Excel Discussion (Misc queries) | |||
| Combine Cells | Excel Worksheet Functions | |||
| Combine cells | Excel Worksheet Functions | |||
Linear Mode
