I have a list of shipping codes and descriptions that is referenced in a
template. I need to copy the list and descriptions and add text to the
beginning of the description. The formula ="Customer "&B2" does this but I
want Customer to be Bold and Red. I tried putting Customer in its own set of
cells setting it to Bold, Red and using =B2&" "&C2 but it does not carry over
the formatting. How can I do this?