| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates and text
How do I put dates from one cell and text from another into a single cell
as 10sep03_GIT |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
dates and text
Thank you very much
"Sloth" wrote: If the cell with the date is formatted as a date (and not text) you can use... A1: 9/10/2003 (formatted as a date) A2: _GIT (formatted as text) A3: =TEXT(A1,"ddmmmyy")&A2 (formatted as text) If the cell with the date is formatted as text you can use A1: 10sep03 (Formatted as text) A2: _GIT (Formatted as text) =A1&A2 (formatted as text) The reason I am clarifying it like this is I have never seen the date formatted like that. "karene" wrote: How do I put dates from one cell and text from another into a single cell as 10sep03_GIT |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dates and text | Excel Discussion (Misc queries) | |||
| text to dates? | Excel Worksheet Functions | |||
| Text with Dates | Excel Discussion (Misc queries) | |||
| Converting Text months to sortable Numbers or Dates | Excel Discussion (Misc queries) | |||
| COUNTIF With Multiple Dates, Columns and Text | Excel Worksheet Functions | |||
Linear Mode
