how do I concatenate color attributes with data

S

sidekickowner

hello excel experts,

I have a frustrating problem...I would like to find out if there is
way to attach the format of the data within cells when using th
concatenate function. For example: if cell A1 had a bold 3 in it, an
A2 had a regular 3 in it, then the result of the concatenation functio
of those two cells would be a cell with one bold 3 and a regular 3 i
it. Does that make sense???

Help Please!!
 
J

JE McGimpsey

Formulas only return values, not formats to their calling cells. You
*can* do this with a VBA Event macro. You need to give a bit more info,
though - will A1 always be bold (easier), or will it sometimes be bold,
and sometimes be not bold? Is the 3 bolded using character formatting or
cell formatting?
 
Top