Home |
Search |
Today's Posts |
#1
|
|||
|
|||
concatenating cells with their formats
If I use the concatenate function or =(cell1)&(cell2), is there a way to pick
up the formats of the original cells, e.g. underline or strikethru? |
#2
|
|||
|
|||
=TEXT(A1,"dd/mm/yyyy")&" "&TEXT(B1,"#,##0.00")
as an example. In other words, pass the format to the text FUNC TION FOR EACHJ CELL. -- HTH Bob Phillips "GDC" wrote in message ... If I use the concatenate function or =(cell1)&(cell2), is there a way to pick up the formats of the original cells, e.g. underline or strikethru? |
#3
|
|||
|
|||
not without using a VBA Event Macro.
In article , GDC wrote: If I use the concatenate function or =(cell1)&(cell2), is there a way to pick up the formats of the original cells, e.g. underline or strikethru? |
#4
|
|||
|
|||
On Mon, 20 Jun 2005 09:51:03 -0700, GDC wrote:
If I use the concatenate function or =(cell1)&(cell2), is there a way to pick up the formats of the original cells, e.g. underline or strikethru? If that formatting is a result of conditional formatting, then you could use the same conditional format formula within your concatenate formula. Otherwise, you would have to use a Visual Basic macro. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
REVISED ?? - populate limited cells w/ set value | Excel Worksheet Functions | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Seed date formats to different year in different cells | Excel Discussion (Misc queries) | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |