Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems CONCATENATE expression
I would like to CONCATENATE the phrases "expire on " with date from
Sheet2!D32 and the phrase "your last Manufacturer's preventive maintanence with revalidation on" with Sheet2!D33 all in Sheet1!A19. I like to see on Sheet1!A19 the following: Expire on April 19, 2009 and your last Manufacturer's preventive maintanence with revalidation was on March 1, 2008. Problem is I'm currently getting the following on Sheet1!A19 : Expire on 39922 and your last Rees Scientific preventive maintanence with revalidation on 39508 Sheet2 D32 = 4/19/09 D33 = 3/1/09 Both D32 and D33 are formated as Dates. Example April 19, 2009. CONCATENATE("expire on ",Sheet2!D32," and your last Rees Scientific preventive maintanence with revalidation on ",Sheet2!D33) Please help.. -- tech1NJ |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems CONCATENATE expression
Try it like this:
="expire on "&TEXT(Sheet2!D32,"mmmm d, yyyy")&" and your last Rees Scientific preventive maintanence with revalidation on "&TEXT(Sheet2!D33,"mmmm d, yyyy") -- Biff Microsoft Excel MVP "tech1NJ" wrote in message ... I would like to CONCATENATE the phrases "expire on " with date from Sheet2!D32 and the phrase "your last Manufacturer's preventive maintanence with revalidation on" with Sheet2!D33 all in Sheet1!A19. I like to see on Sheet1!A19 the following: Expire on April 19, 2009 and your last Manufacturer's preventive maintanence with revalidation was on March 1, 2008. Problem is I'm currently getting the following on Sheet1!A19 : Expire on 39922 and your last Rees Scientific preventive maintanence with revalidation on 39508 Sheet2 D32 = 4/19/09 D33 = 3/1/09 Both D32 and D33 are formated as Dates. Example April 19, 2009. CONCATENATE("expire on ",Sheet2!D32," and your last Rees Scientific preventive maintanence with revalidation on ",Sheet2!D33) Please help.. -- tech1NJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
concatenate problems | Excel Discussion (Misc queries) | |||
concatenate expression error | Excel Worksheet Functions | |||
value expression | Excel Worksheet Functions | |||
need help with expression | Excel Discussion (Misc queries) | |||
Expression | New Users to Excel |