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?

=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?

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?

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