SOLVED

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

Copper Contributor

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 copy/paste.

thanks a lot.

 

1676431591027.png

1 Reply
best response confirmed by MightyMac (Copper Contributor)
Solution

@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.

1 best response

Accepted Solutions
best response confirmed by MightyMac (Copper Contributor)
Solution

@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.

View solution in original post