Replacing the String having Date and Time with = and ""

Whenever writing the date-and-time to an excel sheet the default cell format treats it as date and time and display in the format dd/mm/yyyy hh:mm, rather than displaying as dd-MMM-yyyy HH:mm:ss

 

But coming back to an Excel Sheet, whenever the date and time is enclosed with " "(double quotes) and prefixed with =(equals sign), it treats it as a string holding some values and displays exactly as it is rather than displaying default dd/mm/yyyy hh:mm format.

 

So as per the requirement, to achieve the string containing table data having dd/mm/yyyy hh:mm format need's to replace the date and time enclosed with double quotes with ="dd-MMM-yyyy HH:mm:ss"

 

Eg: 25-Feb-2020 15:27:58 need to be replaced with ="25-Feb-2020 15:27:58"

In the below coding snippets BatchDetails holding string containing table data, needs to be replaced and later assigned into session