inserting comma into date text
 

If I have a column of dates that look like

OCT 10 2007
OCT 10 2007
OCT 08 2007
NOV 07 2007

How can I insert a comma after the Days before the year in order to make
excel recognize all three parts as one date.

inserting comma into date text
 

This formula will give you the date value, but it will be in a different
cell. You could then copy the value back to the original cell.

=DATEVALUE(LEFT(A1,6) & "," & RIGHT(A1,5))

Tom

inserting comma into date text
 

Data Text to Columns Next Next select Date MDY

Format cells as: mmm dd, yyyy


"RyanR8881" wrote:

If I have a column of dates that look like

OCT 10 2007
OCT 10 2007
OCT 08 2007
NOV 07 2007

How can I insert a comma after the Days before the year in order to make
excel recognize all three parts as one date.