Combining text and cell value to create a sentence

[Guest]

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?

 

[Guest]

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

 

[Guest]

YAY. Thanks Bob.

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

 

[Gord Dibben]

Stephanie

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


Gord Dibben Excel MVP