Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return a different date format
Hi
Can anyone help me with this? What i want to do is to take part of two dates and ,a name and combine them into a string. In other words,I want to take the day and month from column A (3101)and B (2410) and the first 4 letters from A (Main) to produce the invoice no D (31012401 Main) A B C D Site From To Invoice no. Main St 31-Jan-08 24-Oct-07 31012401 Main I would be most grateful for suggestions. thanks David |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return a different date format
Trying to guess which columns you really intended, rather than what you said
below, and assuming that where you have 2401 twice you intended 2410, then perhaps try: =TEXT(B2,"ddmm")&TEXT(C2,"ddmm ")&LEFT(A2,4) -- David Biddulph wrote in message ... Hi Can anyone help me with this? What i want to do is to take part of two dates and ,a name and combine them into a string. In other words,I want to take the day and month from column A (3101)and B (2410) and the first 4 letters from A (Main) to produce the invoice no D (31012401 Main) A B C D Site From To Invoice no. Main St 31-Jan-08 24-Oct-07 31012401 Main I would be most grateful for suggestions. thanks David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert date + time text format to date format | Excel Worksheet Functions | |||
I want my combo box to return a date format instead of a number? | Excel Discussion (Misc queries) | |||
using lookup to return more than one answer in date format | Excel Worksheet Functions | |||
Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) |