| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find / Replace
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?? -- Gary''s Student - gsnu200906 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
| Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
| where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| find replace cursor default to find box | Excel Discussion (Misc queries) | |||
Threaded Mode
