Excel-Linking Cells & Formatting

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

Guest

Morning everyone,

I think my question has been addressed in a couple of different ways, but I want to be exactly sure. I have combinations of formulas that display different text paragraphs in a single cell depending on the input. My problem is that the text that is displayed is not retaining its formatting from where it is originally entered (I.e., bold, underline, etc.). Also I am using text wrap, but the rows are not re-sizing to compensate for the different lengths of the resulting text.

Anyone know of a way around these two problems?

Thanks in advance,

Nomad
 
Hi
formulas can't transfer/change formats but only return values. So
probably no chance to achieve your goal with formulas
 
You must log in or register to reply here.

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

keep source formatting when concatenating 1
Copy from Word to Excel, and retain indent, plus word wrap 1
protect cell formatting 3
Conditionally formatting text and numbers differently 1
FORMATTING CELLS 3
Combining a string of text 3
retain custom date format "text" when pasting or reformatting data 2
Excel Text Formula 2

Back
Top