how do I concatenate color attributes with data

  • Thread starter Thread starter sidekickowner
  • Start date Start date
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!!
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Color within Concatenate 2
Concantenate which keeps bold of some parts. 5
undo concatenated cells 2
undo concatenated cells 1
BOLD WORDS IN CONCATENATE FORMULA 1
Excel Concatenate with line breaks but ignore blank cells 3
How do I bold face text1 but not others in a concatenate string? 1
Concatenate not working 2

Back
Top