The Replace function does not seem to keep formatting when applied to cells with more than one format (different fonts, sizes, superscript/subscript, etc).
Is there a way to keep the formats intact?
The example below replaces the characters "and" with "but", but all other formatting is lost.
![]()
Please Login or Register to view this content.
Bookmarks