locking data
 

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

locking data
 

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