I'm very new to macros but I have a problem that's probably pretty easy for some of you on here. I have several spreadsheets with approximately 100 rows and columns each. Some of the columns are supposed to be formatted as dates but they are entered as text (ex, Jan 05 2023 8:24 AM). I can't sort as a date in this format and changing the format to "Date" doesn't work. I found that when I add a comma between the day and year (05 and 2023 in my example) the cell converts to date format.
I think I need a macro to look for all cells in this format (3 text characters then a blank and 2 numbers) and insert a comma into the 7th position.
Can somebody help me out or offer a simpler approach?
Thanks in advance.
Sample data.xlsx
Bookmarks