|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 21st, 2009, 08:44 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What's Wrong: Concatenation and Function
="Top "&$B$2&" Part Numbers by CORRS " &F2&TEXT($D$2,"mmmm d yyyy")
When I enter this in a cell I keep getting "0" as the result. It works fine until I place the Text function on the end. The result is supposed to be as follows: Top 16 Part Numbers by CORRS for the 6 Month Period Ending April 30, 2009 Thank you! 
|
|
#2
May 21st, 2009, 09:03 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What's Wrong: Concatenation and Function
Works for me with a number in B2, the appropriate string in F2 and a date in
D2 Do you get nothing but a 0? Gord Dibben MS Excel MVP On Thu, 21 May 2009 12:44:17 -0700, Walter wrote: ="Top "&$B$2&" Part Numbers by CORRS " &F2&TEXT($D$2,"mmmm d yyyy") When I enter this in a cell I keep getting "0" as the result. It works fine until I place the Text function on the end. The result is supposed to be as follows: Top 16 Part Numbers by CORRS for the 6 Month Period Ending April 30, 2009 Thank you!
|
|
#3
May 21st, 2009, 09:53 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What's Wrong: Concatenation and Function
It should work...
make sure that B2=Top 16 F2= for the 6 Month Period Ending and D2 = April 30, 2009 as a date (not text) "Walter" wrote: ="Top "&$B$2&" Part Numbers by CORRS " &F2&TEXT($D$2,"mmmm d yyyy") When I enter this in a cell I keep getting "0" as the result. It works fine until I place the Text function on the end. The result is supposed to be as follows: Top 16 Part Numbers by CORRS for the 6 Month Period Ending April 30, 2009 Thank you!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
