Date paste issue

%3CLINGO-SUB%20id%3D%22lingo-sub-2385591%22%20slang%3D%22en-US%22%3EDate%20paste%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2385591%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%20%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20have%20problem%20when%20i%20export%20report%20from%20website%20it%20came%20as%20html%20website%20and%20i%20have%20to%20copy%20and%20paste%20it%20on%20sheet%26nbsp%3B%3C%2FP%3E%3CP%3E1st%20problem%20when%20i%20copy%20and%20paste%20name%20come%20on%20seperate%20cells%20however%20when%20i%20paste%20on%20google%20sheet%20it%20came%20on%20same%20cell%20like%20html%26nbsp%3B%3C%2FP%3E%3CP%3E2nd%20problem%20report%20export%20date%20like%2019%2F06%2F2021%20which%20excel%20not%20understand%20it%20when%20i%20transfer%20to%20date%20like%2019%20-%20jun%20-%202021%20and%20i%20can't%20find%20solution%20for%20that%26nbsp%3B%3C%2FP%3E%3CP%3Ebelow%20print%20screen%20from%20web%20html%20report%20and%20its%20view%20on%20excel%202016%20and%20on%20google%20sheets%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22lvrman_1-1621980949585.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F283736iEED9A3D69FCDBD36%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22lvrman_1-1621980949585.png%22%20alt%3D%22lvrman_1-1621980949585.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22lvrman_2-1621981153253.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F283742i96EB92EE932B0017%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22lvrman_2-1621981153253.png%22%20alt%3D%22lvrman_2-1621981153253.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2385591%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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