keep source formatting when concatenating



In cell A1, my data are in bold font and underlined. In cell B1, my data are
in bold font only. In cell C1, my data do not have any special formatting.
When concatenating to D1 (=CONCATENATE(A1&" "&B1&" "&C1), the source
formatting is not displaying in D1, i.e., nothing appears bolded or
underlined. Is there a way to do this?



Dave Peterson

You have two problems.

#1. Formulas don't allow this kind of formatting.
#2. Worksheet functions like this bring back values--not formats.

Maybe you can convert to values and reformat that?????

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