Guys,

I have been pointed here from another thread as am trying to create a VBA macro that when I press a button the following occurs....


Column B (the date and time) reduced from "20190520 07:38:31.332442 +0000" to just "20190520" which just shows the date.

and

Column U reduced from "20190520 07:38:31.332442 +0000" to just "07:38:31"

and

IF Cell A2 is populated then Cell N2 will be populated with "N" (unless i overwrite)

Of course I will have multiple lines on the spreadsheet so we assume the macro will perform this across all lines.

thanks in advance