Can you cut that column and paste to a new
worksheet then run EditReplace on it?

Then paste back into original spot.

I'm curious... why copy it to another sheet, do the replace and then copy it
back instead of just doing the replace at the original location?

Rick Rothstein (MVP - Excel)