Excel doesn't support that kind of formatting with formulas.

If you converted to values, you could format each cell with that character by
character formatting.

dick wrote:

I have 2 column of info. My first column has 100 different items and my
second column has numbers 1 through 100 in sequence. I want to concatenate
the 2 columns and not have the second column of numbers show in the
concatenated column. I formatted the second column's numbers to be white, to
match the cells white backgroung. When I concatenate the columns the
resulting column has the numbers in black again, I need for them to stay white
any ideas
Thank you in advance

--

Dave Peterson