Find (CTRL+F) Values in Contact Column

It appears impossible to find values in a contact column using a CTRL+F/Command+F find function. I've attempted searching by the contact name (Joe Smith), contact email ([email protected]), and even the messier value that copies and pastes out of a given contact cell (Joe Smith <[email protected]>).

I need to find and replace values in a sheet in bulk when a given assigned party turns over or leaves a project.

Does anyone know something I don't?