> You could easily generate this using ColdFusion while outputting an HTML
> table.
true.
> However, in Excel, you should be able to click the little black box in
> the bottom-right corner of a highlighted cell and drag it down. The
> cell references in the formula should update to the new loca
not what it is doing?
M!ke
-Original Message-
From: William Bowen [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 17, 2005 11:03 AM
To: CF-Community
Subject: An excel question
I have the following formula in cell G2 in a spreadsheet.
=CONCATENATE(B2,"-",C2,"-",D
n/m - found the answer!
thanks!
On Thu, 17 Feb 2005 09:02:44 -0800, William Bowen
<[EMAIL PROTECTED]> wrote:
> I have the following formula in cell G2 in a spreadsheet.
>
> =CONCATENATE(B2,"-",C2,"-",D2,"-",E2,"-",F2)
>
> It works as expected on row 2.
>
> Now here is the problem. If I add a R
I have the following formula in cell G2 in a spreadsheet.
=CONCATENATE(B2,"-",C2,"-",D2,"-",E2,"-",F2)
It works as expected on row 2.
Now here is the problem. If I add a Row 3, I have to enter (usually
copy/paste) this formula again. and then edit the formula to be:
=CONCATENATE(B3,"-",C3,"-",D