Date paste issue

Occasional Visitor

Hi all , 

 

i have problem when i export report from website it came as html website and i have to copy and paste it on sheet 

1st problem when i copy and paste name come on seperate cells however when i paste on google sheet it came on same cell like html 

2nd problem report export date like 19/06/2021 which excel not understand it when i transfer to date like 19 - jun - 2021 and i can't find solution for that 

below print screen from web html report and its view on excel 2016 and on google sheets 

 

lvrman_1-1621980949585.png

lvrman_2-1621981153253.png

 

 

0 Replies