Group the duplicate Date to one cell

  • Thread starter Thread starter Alan Tang
  • Start date Start date
A

Alan Tang

Hello:

I would like to group the date into one cell. Would you mind to give
me a help?

Source Data! only one column!
Date
-----------------------------
08/01/2003 09:02:28.114
08/01/2003 09:32:28.218
08/02/2003 09:32:28.218
08/02/2003 19:22:28.218
08/03/2003 07:25:28.218
08/03/2003 10:12:28.218
08/03/2003 21:56:28.218
08/03/2003 22:32:28.218

Result!
-----------------------------
08/01/2003
08/02/2003
08/03/2003

Thanks!
 
If the date is already in one cell then the custom
formatting or Date/Time format will change the entry to
any format you like.

If date is in column A and time is in column B then
column c is =A1 & B1

The ampersand joins the two sets of data.
 
Back
Top