dates and text
 

How do I put dates from one cell and text from another into a single cell
as 10sep03_GIT

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