column separators disappear when copy and paste

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3174429%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3Ecolumn%20separators%20disappear%20when%20copy%20and%20paste%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3174429%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI%20use%20copy%20and%20paste%20a%20lot%20-%20but%20lately%20the%20column%20separation%20disappears%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E601491%205814%2023794%2029608%20150821%206383%2022449%2028832%3CBR%20%2F%3E601571%206335%2044139%2050473%20127377%205196%2066284%2071480%3CBR%20%2F%3E601581%204940%2062280%2067220%20129366%206933%2044131%2051063%3CBR%20%2F%3E602071%208947%2010353%2019299%2074941%207258%2010551%2017809%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3Ebecomes%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348793iFF274DD079D19EC5%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22kerstin1615_0-1645031480925.png%22%20alt%3D%22%5C%26quot%3Bkerstin1615_0-1645031480925.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Ewhich%20is%20difficult%20to%20separate%20in%20text-to-columns%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EIt%20used%20to%20work%20-%20I%20was%20looking%20for%20a%20way%20to%20get%20rid%20of%20too%20many%20spaces%20and%20now%20I%20can't%20find%20what%20I%20changed%20-%20I%20assume%20I%20did%20something%20wrong%20with%20settings%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3174429%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3174429%22%20slang%3D%22en-US%22%3Ecolumn%20separators%20disappear%20when%20copy%20and%20paste%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3174429%22%20slang%3D%22en-US%22%3E%3CP%3EI%20use%20copy%20and%20paste%20a%20lot%20-%20but%20lately%20the%20column%20separation%20disappears%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E601491%205814%2023794%2029608%20150821%206383%2022449%2028832%3CBR%20%2F%3E601571%206335%2044139%2050473%20127377%205196%2066284%2071480%3CBR%20%2F%3E601581%204940%2062280%2067220%20129366%206933%2044131%2051063%3CBR%20%2F%3E602071%208947%2010353%2019299%2074941%207258%2010551%2017809%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebecomes%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22kerstin1615_0-1645031480925.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348793iFF274DD079D19EC5%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22kerstin1615_0-1645031480925.png%22%20alt%3D%22kerstin1615_0-1645031480925.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Ewhich%20is%20difficult%20to%20separate%20in%20text-to-columns%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20used%20to%20work%20-%20I%20was%20looking%20for%20a%20way%20to%20get%20rid%20of%20too%20many%20spaces%20and%20now%20I%20can't%20find%20what%20I%20changed%20-%20I%20assume%20I%20did%20something%20wrong%20with%20settings%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3174429%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I use copy and paste a lot - but lately the column separation disappears

 

601491 5814 23794 29608 150821 6383 22449 28832
601571 6335 44139 50473 127377 5196 66284 71480
601581 4940 62280 67220 129366 6933 44131 51063
602071 8947 10353 19299 74941 7258 10551 17809

 

becomes

kerstin1615_0-1645031480925.png

which is difficult to separate in text-to-columns

 

It used to work - I was looking for a way to get rid of too many spaces and now I can't find what I changed - I assume I did something wrong with settings 

2 Replies

@kerstin1615 

You copy/paste from one place within Excel sheet to another; or you copy/paste from Web to Excel; or something else?

@Sergei Baklan Sorry should have tried restarting the computer.. (Dell's latest bunch of drivers and so on). Works again. Only my other problem remains - a screen reader - in English that I can't turn off - I've tried windows - ctrl o sv - and Inställningar whatever that is in English - where you for example set the language of the voice - in my native language Swedish, and off course I've set screen reader to OFF. But - every calulation, yes the numbers in English..