You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.

Irene Galente asked if she can combine the name data in a number of Excel columns into a single cell. In Irene’s spreadsheet the first column displays each person’s “title” … ...