![]()
Sub Maybe() Dim c As Range For Each c In Range("A2:A" & Cells(Rows.Count, 1).End(xlUp).Row) c.Offset(, 1).Value = CStr(Mid(c, 4, 2) & "/" & Mid(c, 1, 2) & "/" & Mid(c, 7, 4) & " " & Mid(c, 12, 5)) Next c End Sub
![]()
Sub Maybe() Dim c As Range For Each c In Range("A2:A" & Cells(Rows.Count, 1).End(xlUp).Row) c.Offset(, 1).Value = CStr(Mid(c, 4, 2) & "/" & Mid(c, 1, 2) & "/" & Mid(c, 7, 4) & " " & Mid(c, 12, 5)) Next c End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks