Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
keep source formatting when concatenating
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenating & Formatting | Excel Discussion (Misc queries) | |||
Source Formatting | Excel Discussion (Misc queries) | |||
retain formatting when concatenating | Excel Worksheet Functions | |||
concatenating and formatting area code and phone number columns | Excel Worksheet Functions | |||
keep $ formatting when concatenating | Excel Discussion (Misc queries) |