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?