concatenating cells with their formats

G

GDC

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

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

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?
Click to expand...

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
 
Top