Forum Discussion
Solved
Reformatting text date doesn't work in Microsoft 365 Excel
When I copy a list of dates from a web page into an Excel spreadsheet, if the dates are formatted as text (ex. September 23, 2003) then when I try to change the date format to 9/23/2003 nothing happe...
Does this work?
=LET(d,SUBSTITUTE(H122,CHAR(160)," "),DATEVALUE(TEXTAFTER(TEXTBEFORE(d,",")," ")&"-"&TEXTBEFORE(d," ")&"-"&TEXTAFTER(d," ",2)))
Does this work?
=LET(d,SUBSTITUTE(H122,CHAR(160)," "),DATEVALUE(TEXTAFTER(TEXTBEFORE(d,",")," ")&"-"&TEXTBEFORE(d," ")&"-"&TEXTAFTER(d," ",2)))
Yes, thank you!
