concatenating cells with their formats

[Guest]

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?

 

[Bob Phillips]

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

 

[JE McGimpsey]

not without using a VBA Event Macro.

 

[Ron Rosenfeld]

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