Copy and paste data from an Excel Online cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1363006%22%20slang%3D%22en-US%22%3ECopy%20and%20paste%20data%20from%20an%20Excel%20Online%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1363006%22%20slang%3D%22en-US%22%3E%3CPRE%3E%3CSPAN%3EGood%20afternoon!%20I%20have%20been%20working%20with%20Excel%20Online%20for%20over%20a%20year%20now%2C%20no%20problems%20have%20been%20observed.%0A%0A2%20days%20ago%20there%20was%20a%20problem%20of%20the%20following%20nature%3A%0A%0AWhen%20you%20select%20and%20copy%20certain%20text%20in%20a%20cell%2C%20all%20the%20text%20in%20the%20cell%20is%20copied%2C%20not%20the%20part%20that%20you%20copied.%0A%0AWhen%20you%20paste%20the%20copied%20text%20into%20another%20cell%20(there%20is%20already%20text%20there%2C%20the%20new%20text%20is%20inserted%20after%20the%20previous%20text)%2C%20all%20the%20previous%20text%20is%20deleted%2C%20and%20only%20the%20one%20that%20was%20copied%20and%20pasted%20remains.%0A%0AWhen%20you%20paste%20text%20in%20the%20top%20line%2C%20it%20is%20copied%20normally%2C%20but%20with%20quotes.%0A%0AWho%20faced%20such%20a%20problem%3F%20I%20would%20really%20appreciate%20your%20help!%0A%0AThanks!%3C%2FSPAN%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1363006%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1363393%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20and%20paste%20data%20from%20an%20Excel%20Online%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1363393%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F657641%22%20target%3D%22_blank%22%3E%40Shamil_Shaykhutdinov%3C%2FA%3E%26nbsp%3B%2C%20I%20can%20not%20watch%20your%20video%2C%20but%20I%20am%20understood%20the%20situation.%3C%2FP%3E%3CP%3EIf%20I%20copy%205%20cells%2C%20when%20paste%20only%20first%204%20lines%2C%20the%20last%20line%20was%20pasted%20blank%20values.%3C%2FP%3E%3CP%3EA%20see%20an%20another%20bug%20when%20I%20paste%20date%20cells.%3CBR%20%2F%3EEx.%20copy%20cells%20with%20value%2001%2F01%2F2020%3CBR%20%2F%3Epaste%20result%20like%2031%2F12%2F2015%3CBR%20%2F%3EOr%20copy%2025%2F12%2F2020%20(Christimas%20Day)%3CBR%20%2F%3Epaste%2025%2F12%2F2016%20another%20year%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESometimes%20changes%201%20day%20before%20or%20after%20the%20correct%20date.%3CBR%20%2F%3EI%20am%20tottaly%20unsure%20to%20do%20anything%20using%20date%20field.%3C%2FP%3E%3CP%3EI%20had%20tested%20Excel%202016%20and%202019%20versions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20luck%20to%20us%20to%20discover%20the%20solution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor
Good afternoon! I have been working with Excel Online for over a year now, no problems have been observed.

2 days ago there was a problem of the following nature:

When you select and copy certain text in a cell, all the text in the cell is copied, not the part that you copied.

When you paste the copied text into another cell (there is already text there, the new text is inserted after the previous text), all the previous text is deleted, and only the one that was copied and pasted remains.

When you paste text in the top line, it is copied normally, but with quotes.

Who faced such a problem? I would really appreciate your help!

Thanks!
1 Reply
Highlighted

Hi @Shamil_Shaykhutdinov , I can not watch your video, but I am understood the situation.

If I copy 5 cells, when paste only first 4 lines, the last line was pasted blank values.

A see an another bug when I paste date cells.
Ex. copy cells with value 01/01/2020
paste result like 31/12/2015
Or copy 25/12/2020 (Christimas Day)
paste 25/12/2016 another year

 

Sometimes changes 1 day before or after the correct date.
I am tottaly unsure to do anything using date field.

I had tested Excel 2016 and 2019 versions.

 

Good luck to us to discover the solution.