View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cstwoplus cstwoplus is offline
external usenet poster
 
Posts: 7
Default 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?