| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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? |
|
#5
|
|||
|
|||
|
Try this one:
="Recoveries " &TEXT(E2,) & " from " &TEXT(B1,) & " to " &TEXT(A1,)
__________________
Justin Labenne www.jlxl.net |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining numerical and drop-down text in a single cell | Excel Discussion (Misc queries) | |||
| Help inserting a Cell Value in a Text Cell | Excel Worksheet Functions | |||
| How do I create a bulleted list text format inside cell? | Excel Discussion (Misc queries) | |||
| How to create a hyperlink in excel, using the text in a cell. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
