Find and replace text
When i am find the text after replace, font styles are affected(changed) in the cell contents.
Please any idea?
Thanks.
4
votes
Annadurai M
shared this idea
1 comment
-
Michael Bryson
commented
To clarify what I think the OP is asking, when using the find/replace function the substituted text not only replaces the original text but it also replaces the text format.
For example: if you have a dozen different cells with "x subscript 2" used as a label, and you want to replace the "subscript 2" with "subscript 3" then using the find/replace function will replace "subscript 2" with "3" but the subscript format will have been removed in each cell.
It would be nice if this didn't happen.