Find / Replace

[Gary''s Student]

I am trying to help a colleague who is a small problem with Find/Replace.
Her worksheet has cells with text in them like:

Health and Wealth

She wants to replace the “and†with “orâ€. Find/Replace works just fine.
However in the original text, the word “Wealth†is in Bold font. After the
Find/Replace, the Bold vanished. I pointed out that she could manually edit
the cells in the formula bar and preserve the mixed formatting. She said
this is not an option because of the large number of cells involved. I
countered with a suggestion that we could make a small macro to automate the
process. Sadly, the woman suffers from macrophobia and will not consider
this option either.

Is there a way to perform Find/Replace and preserve mixed formatting??

 

[Jacob Skaria]

Interesting Garry. (macrophobia !!)

You must have checked this with her. If her requirement is to find/replace
the whole cell ie; If all 'Health and Wealth' entries are to be replaced with
'Health or Wealth' keeping Wealth in bold; try the below.
--Find 'Health or Wealth' and hit FindAll
--From the list select all;so that these cells are selected
--Press F2 > Edit or to and
--Ctrl + Enter

If this post helps click Yes

 

[Gary''s Student]

Very nice!
Your solution did not occur to me.
Thanks (Margie extends her thanks as well)!

 

[Jacob Skaria]

Cheers both !!!! and thanks for that new word...

Very nice!
Your solution did not occur to me.
Thanks (Margie extends her thanks as well)!