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"
<[email protected]> 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,)


--
JustinLabenne