That would be a thought but I would have to highlight the first 10-15
characters of every cell one at a time and change the format.. I would have
to do this ~400 times... I just thought there might be an easy way to get the
formatting to carry over from one cell to the combined formula..

"Gary''s Student" wrote:

You need to copy the formulas and paste/special/value elsewhere. The result
will be a text string. You can then format individual characters
--
Gary''s Student - gsnu200723