keep source formatting when concatenating

C

cstwoplus

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

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

Similar Threads

Combining a string of text 3
Concantenate which keeps bold of some parts. 5
& to combine cells/Keep formats 1
Changes Required In Macro Code 2
Forcing User inputs 1
Formatting text which is result of formula 3
Conditional Formatting with if statement 1
keep $ formatting when concatenating 6

Top