If the stuff in the cells remain formulas, then yep, you're out of luck.

But if you paste special|values, then it'll work.

Christopher wrote:

Don't worry too much about being nice. I appreciate the answer, although I
was hoping for a different one. All the text is either generated by a
formula or copied from the input page (which is a formula too, I guess), so
it looks like I'll be out of luck. I'm still going to try your code to see
if it'll help at all. Thanks.

"Dave Peterson" wrote:

Those first two sentences could have been nicer.

Excel doesn't allow this character by character formatting in formulas or
numbers--only text.

--

Dave Peterson