| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find / Replace
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 --------------- Jacob Skaria "Gary''s Student" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find / Replace
Very nice!
Your solution did not occur to me. Thanks (Margie extends her thanks as well)! -- Gary''s Student - gsnu200906 "Jacob Skaria" wrote: 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 --------------- Jacob Skaria "Gary''s Student" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find / Replace
Cheers both !!!! and thanks for that new word...
"Gary''s Student" wrote: Very nice! Your solution did not occur to me. Thanks (Margie extends her thanks as well)! -- Gary''s Student - gsnu200906 "Jacob Skaria" wrote: 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 --------------- Jacob Skaria "Gary''s Student" wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
