dates and text

K

karene

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

karene

Thank you very much

Sloth said:
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.
Click to expand...
 
Top