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.