I'm more of an Access guy than an Excel guy, but I help my coworkers when I can. One of them showed me a worksheet (Excel 2007) that, when you enter a formula in a cell -- e.g., =A2&G2&J2 -- and then try to copy it down a column, behaves strangely. The formula copies down the column, and the cell references appear to have adjusted themselves on each row, but the RESULT is absolutely the same as on the first row. Anybody ever seen that? Is it some obscure setting somewhere? Only way I've found to fix it is to dump the entire worksheet to tab-delimited text, then bring it back into an entirely new workbook.