Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
JOINING OF TEXT & DATE
Hello!
Text = "Receipts from:" Date = 10/5/06. (This date will in a different cell and will change every month) The decription I desire will be: "Receipts from: "1st to 5th October" or any variation thereof as long as it shows the period Thanks SJ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
About Text to Date | Excel Discussion (Misc queries) | |||
turn off convert text to date (i.e. 4-9 to April 9, 2006) | Excel Worksheet Functions | |||
How do I grab the date from a text string? | Excel Worksheet Functions | |||
Macro to convert text to date | Excel Worksheet Functions | |||
EXTRACT TEXT FROM A DATE | Excel Worksheet Functions |