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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

The updated 'Corel Painter inside Photoshop' plugin ParticleShop offers new brushes

Best running headphones | Best sport & fitness headphones: 4 brilliant pairs of wireless…