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
Bookmarks