Combining text and cell value to create a sentence
 

In Excel 2000 I have something like the following:
A B C D Inc/Dec
1 April May YTD Goal
2 $75 $50 $10 $200 decreased

I'd like to form a sentence such as

Recoveries decreased from May to April.
I've tried "="Recoveries " &Text(E2) " from" &Text(B1) "to " &Text(A1)
But keep getting "too many arguments".

Any suggestions, or is this possible?

Simply
=Recoveries " & E2 &" from "& B1 & " to " & A1
the Text function is not needed here, but if you DO use it, it takes a 2nd
parameter, like
=TEXT(E20,"#,##0.00") or =TEXT(D12,"mm/dd/yyyy"), not just =TEXT(A1).
HTH
Bob Umlas
Excel MVP


"StephanieH" wrote:

In Excel 2000 I have something like the following:
A B C D Inc/Dec
1 April May YTD Goal
2 $75 $50 $10 $200 decreased

I'd like to form a sentence such as

Recoveries decreased from May to April.
I've tried "="Recoveries " &Text(E2) " from" &Text(B1) "to " &Text(A1)
But keep getting "too many arguments".

Any suggestions, or is this possible?

YAY. Thanks Bob.

"Bob Umlas, Excel MVP" wrote:

Simply
=Recoveries " & E2 &" from "& B1 & " to " & A1
the Text function is not needed here, but if you DO use it, it takes a 2nd
parameter, like
=TEXT(E20,"#,##0.00") or =TEXT(D12,"mm/dd/yyyy"), not just =TEXT(A1).
HTH
Bob Umlas
Excel MVP


"StephanieH" wrote:

In Excel 2000 I have something like the following:
A B C D Inc/Dec
1 April May YTD Goal
2 $75 $50 $10 $200 decreased

I'd like to form a sentence such as

Recoveries decreased from May to April.
I've tried "="Recoveries " &Text(E2) " from" &Text(B1) "to " &Text(A1)
But keep getting "too many arguments".

Any suggestions, or is this possible?

Stephanie

="Recoveries " & E2 & " from " & B1 & " to " & A1


Gord Dibben Excel MVP


On Mon, 13 Jun 2005 10:31:01 -0700, "StephanieH"
wrote:

In Excel 2000 I have something like the following:
A B C D Inc/Dec
1 April May YTD Goal
2 $75 $50 $10 $200 decreased

I'd like to form a sentence such as

Recoveries decreased from May to April.
I've tried "="Recoveries " &Text(E2) " from" &Text(B1) "to " &Text(A1)
But keep getting "too many arguments".

Any suggestions, or is this possible?

Try this one:

="Recoveries " &TEXT(E2,) & " from " &TEXT(B1,) & " to " &TEXT(A1,)