Find and Replace in Excel

  Newuser939 18:38 25 Jan 11

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 11

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

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

What is ransomware and how do I protect my PC from WannaCry?

What I learned from my mentor, Oscar-winning VFX supervisor Phil Tippett

Siri vs Google Assistant