Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |