Prev: do you have examples of make vs. buy models in Excel?
Next: How do I convert rows to columns
From: cstwoplus on 31 Mar 2010 16:06
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?
From: Dave Peterson on 31 Mar 2010 17:37
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?????

cstwoplus wrote:
>
> 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
 | 
Pages: 1
Prev: do you have examples of make vs. buy models in Excel?
Next: How do I convert rows to columns