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