Bug?

%3CLINGO-SUB%20id%3D%22lingo-sub-1947216%22%20slang%3D%22en-US%22%3EBug%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1947216%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20copy%20lines%20from%20the%20excel%20desktop%20app%20and%20paste%20them%20to%20online.%26nbsp%3B%20However%2C%20if%20any%20of%20the%20lines%20contain%20a%20carriage%20return%2C%20they%20paste%20with%20multiple%20lines%20in%20the%20spreadsheet%20online%2C%20even%20though%20it%20is%20a%20single%20line%20in%20the%20desktop%20app.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20isn't%20an%20undocumented%20feature%2C%20because%20it%20wouldn't%20be%20a%20very%20good%20one.%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20prevent%20it%20from%20adding%20line%20like%20this%3F%26nbsp%3B%20I'd%20really%20rather%20not%20have%20to%20save%20a%20whole%20new%20copy%20online%20every%20time%20I%20want%20to%20add%20a%20line%20to%20this%20report.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20desktop%20version%20I%20am%20using%20is%202013.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1947216%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1947451%22%20slang%3D%22en-US%22%3ERe%3A%20Bug%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1947451%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F868443%22%20target%3D%22_blank%22%3E%40Marke525%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20you%20paste%20the%20data%2C%20%3CSTRONG%3E%22Paste%20Value%22%3C%2FSTRONG%3E%20it%20will%20place%20your%20data%20in%20one%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%20%26amp%3B%20like%20it%20to%20help%20the%20other%20members%20find%20it%20more.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Visitor

I am trying to copy lines from the excel desktop app and paste them to online.  However, if any of the lines contain a carriage return, they paste with multiple lines in the spreadsheet online, even though it is a single line in the desktop app. 

I hope this isn't an undocumented feature, because it wouldn't be a very good one. 

Is there any way to prevent it from adding line like this?  I'd really rather not have to save a whole new copy online every time I want to add a line to this report.

 

The desktop version I am using is 2013.

1 Reply

Hi @Marke525 

 

When you paste the data, "Paste Value" it will place your data in one cell.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.