Combining text and cell value to create a sentence

S

StephanieH

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?
 
B

Bob Umlas, Excel MVP

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
 
S

StephanieH

YAY. Thanks Bob.

Bob Umlas said:
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
Click to expand...
 
G

Gord Dibben

Stephanie

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


Gord Dibben Excel MVP
 
J

JustinLabenne

Try this one:

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