concatenate
I'm using the concatenate function (or the "&") to combine 2 cells. One cell
is the number 2006 and the other cell is the number 1. I've added a space using quotes in between so the answer should be "2006 1." In one spreadsheet this works fine. I try the same procedure in another open spreadsheet but it gives me the #value error. I've even cut the three cells (the last of which includes the formula) to the new spreadsheet, and it gives the same error. The links are correct, it just doesn't work consistently. Any thoughts? tia, Dave |
concatenate
So you're using a formula like =A1&" "&B1 The only reason I can see for a #VALUE! error there is that A1 or B1 contains a #VALUE! error -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=506764 |
concatenate
"Dave Breitenbach" wrote...
I'm using the concatenate function (or the "&") to combine 2 cells. One cell is the number 2006 and the other cell is the number 1. I've added a space using quotes in between so the answer should be "2006 1." In one spreadsheet this works fine. I try the same procedure in another open spreadsheet but it gives me the #value error. I've even cut the three cells (the last of which includes the formula) to the new spreadsheet, and it gives the same error. The links are correct, it just doesn't work consistently. Tools Options, select the Transition tab in the Options dialog, uncheck Transition Formula Evaluation. |
concatenate
Thanks. That did it. I had always thought that the options you selected
applied to any workbook you were using in that version of excel until you changed the options. Can you explain what the transition formula evaluation is attempting to accomplish? "Harlan Grove" wrote: "Dave Breitenbach" wrote... I'm using the concatenate function (or the "&") to combine 2 cells. One cell is the number 2006 and the other cell is the number 1. I've added a space using quotes in between so the answer should be "2006 1." In one spreadsheet this works fine. I try the same procedure in another open spreadsheet but it gives me the #value error. I've even cut the three cells (the last of which includes the formula) to the new spreadsheet, and it gives the same error. The links are correct, it just doesn't work consistently. Tools Options, select the Transition tab in the Options dialog, uncheck Transition Formula Evaluation. |
concatenate
"Dave Breitenbach" wrote...
.... Can you explain what the transition formula evaluation is attempting to accomplish? .... I could, but you'd get a more complete answer by pressing [F1] to bring up online help, then search its index for the keyword transition. |
All times are GMT +1. The time now is 08:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com