Hey there, need some help with this one please, the below text is in general format and needs to stay that way.
01/06/2023 07:45:26 must be rearranged to 2023-06-01 07:45:26. there is a space between the date and time. would appreciate a formula, i have found this on the forum but it throws value
=(RIGHT(A2,4)&TEXT(LEFT(A2,LEN(A2)-4),"0000"))+0
01/06/2023 07:45:26 must be rearranged to 2023-06-01 07:45:26. there is a space between the date and time. would appreciate a formula, i have found this on the forum but it throws value
=(RIGHT(A2,4)&TEXT(LEFT(A2,LEN(A2)-4),"0000"))+0