Hello,
In Excel I've a column with all kinds of different dates. The format of the dates is 'Month day, year - time' (example: 'March 7, 2005 - 11:35'. The problem is that it's saved as text. I've copied these dates from a table form a website and can't edit it there. Since this will be a common handeling, I would like to have some kind of VBA-code that with recode this text to a date. Is this possible? Thanks allready for your effort!
Greetings,
Maik
In Excel I've a column with all kinds of different dates. The format of the dates is 'Month day, year - time' (example: 'March 7, 2005 - 11:35'. The problem is that it's saved as text. I've copied these dates from a table form a website and can't edit it there. Since this will be a common handeling, I would like to have some kind of VBA-code that with recode this text to a date. Is this possible? Thanks allready for your effort!
Greetings,
Maik