Combining Cells BUT Keeping source formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I wish to combine cells in a worksheet - simple enough. However need to
keep the source cell formatting eg one is BOLD and one is ITALLIC. When I
combine using the stabdard commands eg =CONCATENATE(A2," ",B2) or =A2&" "&B2
the resulting combined cell resorts to the foramtting in the first cell.

Any offers
 

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

TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
Format part of text in concatenated field 4
Bold part of combined cell 4
USE CONCATENATE function to connect 2 formulas 4
formula cell format change 3
Concatenating two text strings, formula is right, cell output is w 3
Excel Concatenate with line breaks but ignore blank cells 3
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1

Back
Top