I have an excel file， the excel form as follows
In Row D, from D2 is 16 December 2019 , how could I change the content to 20191216?
in Row E, i want to change the data ISIN: to ISIN delete the :
in Row F , i want to change the data BACE/ to BACE , delete the /
how could I achieve these function ? anybody give me demo code ?
thanks a lot in advance.