How to extract date-time from a string and format it to YYYY-MM-DD 00:00:00 & add back to the string in a excel to same column? The column can vary.So,it should allow to work on any column.
Input values in a column:
Monday, March 11, 2013
3/11/2013 6:78:3|D
03/11/13 6:78:3|D
3/1/13 6:78:3|Date
2013/11/13 23:42|D
2013/11/13 6:78:3|D
the date is|3/11/13 6:78:3|D
3/11/2013 6:78:3|D
03/11/13 6:78:3|D
Required Output column:
2013-11-03 00:00:00
2013-11-03 06:78:03|D
2013-11-03 06:78:03|D
2013-03-01 06:78:03|Date
2013-11-13 23:42:00|D
2013-11-13 06:78:03|D
the date is|2013-11-03 06:78:03|D
2013-11-13 06:78:03|D
2013-11-13 06:78:03|D
Input values in a column:
Monday, March 11, 2013
3/11/2013 6:78:3|D
03/11/13 6:78:3|D
3/1/13 6:78:3|Date
2013/11/13 23:42|D
2013/11/13 6:78:3|D
the date is|3/11/13 6:78:3|D
3/11/2013 6:78:3|D
03/11/13 6:78:3|D
Required Output column:
2013-11-03 00:00:00
2013-11-03 06:78:03|D
2013-11-03 06:78:03|D
2013-03-01 06:78:03|Date
2013-11-13 23:42:00|D
2013-11-13 06:78:03|D
the date is|2013-11-03 06:78:03|D
2013-11-13 06:78:03|D
2013-11-13 06:78:03|D