Thanks Donkey and MallyCat. That's helpful.

MallyCat. I see what you're saying about =Char(39). If I type =Char(39) into a cell, is there anyway to append other strings to that value? When I enter letters after that, like "=Char(39) Apple" i get the message: "The formula you typed contains an error"

If i could somehow append other letters to that value, that would work for sure. Is that possible?