Forum Discussion

MightyMac's avatar
MightyMac
Copper Contributor
Feb 15, 2023
Solved

How to using formula/function and keep text formatting, like copy/paste

Hi there, I used fomula/fuction on a cell, and it's text formatting like bold underline typeface color etc. was lost.  How can I use a formula while keeping its text formatting unchaged? Just like ...
  • HansVogelaar's avatar
    Feb 15, 2023

    MightyMac 

    It is not possible to format parts of the result of a formula differently than the rest.

    A formula such as =A2 can only copy the value of A2, not its formatting.

Resources