Text to date formula?

  • Thread starter Thread starter AB
  • Start date Start date
A

AB

Hi, I entered the dates in separate columns eg (A1) 22, (B1) Nov, (C1) 2003;
thinking I could join them up later.
Tried Concatenate, but it doesn't leave a space between values. eg.
22Nov2003. Any ideas?

Many thanks
Althea
 
Althea,

If all you want to do is include spaces, you can use:
=A1&" "&B1&" "&C1

HTH,
Felipe
 
HI Felipe, thanks for that, I'd tried something similar but had forgotten to
leave a space between the quotes.
Althea
 
Althea

=A1&" "&B1&" "&C1

Note: these will not be real dates, just text.

To get real dates use =DATEVALUE(A1&" "&B1&" "&C1) and format the cell as
Date.

Gord Dibben XL2002
 
Many thanks for all the help.
Althea

Althea

=A1&" "&B1&" "&C1

Note: these will not be real dates, just text.

To get real dates use =DATEVALUE(A1&" "&B1&" "&C1) and format the cell as
Date.

Gord Dibben XL2002
Click to expand...
 
Back
Top