Find and Replace in Excel

  Newuser939 18:38 25 Jan 2011

I have used an Excel 2010 spreadsheet to prepare a rota of tasks for the local church. Some of the tasks would be carried out by two people working together. Accordingly, a single cell might contain the text "Jim & Bill". I would like to print out individual copies of the spreadsheet with each person's name highlighted so that they can easily see when they will be needed. However, if, for example, I use Find and Replace to find just Jim and replace it with just Jim in red, Excel actually replaces the whole of Jim & Bill in red. In effect, I am asking if there is a way to replace just part of a cell so that Jim could appear in red whilst Bill remains black.

  GaT7 19:05 25 Jan 2011

Try selecting the 'Match entire cell contents' box on the Replace tab. G

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Graphic tees: 14 best websites to find your next T-shirt

How to update iOS on iPhone or iPad

Les meilleures applications pour enfants 2017