How can I copy+paste rich text to just one column on Google Sheets?











up vote
-1
down vote

favorite












I've googled this issue and have found plenty of information on how to "split text into different columns", but I want to copy+paste the text into just one column on the google sheet.



Herewith is a picture that shows what I'm getting (on the left), and what I actually need (on the right). I've tried CTRL+SHIFT+V but it doesn't work either. I did it in the past, but can't remember how.



copy+paste comparison










share|improve this question









New contributor




maicart is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.




















  • Paste it in notepad first may work
    – roozbeh S
    2 days ago















up vote
-1
down vote

favorite












I've googled this issue and have found plenty of information on how to "split text into different columns", but I want to copy+paste the text into just one column on the google sheet.



Herewith is a picture that shows what I'm getting (on the left), and what I actually need (on the right). I've tried CTRL+SHIFT+V but it doesn't work either. I did it in the past, but can't remember how.



copy+paste comparison










share|improve this question









New contributor




maicart is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.




















  • Paste it in notepad first may work
    – roozbeh S
    2 days ago













up vote
-1
down vote

favorite









up vote
-1
down vote

favorite











I've googled this issue and have found plenty of information on how to "split text into different columns", but I want to copy+paste the text into just one column on the google sheet.



Herewith is a picture that shows what I'm getting (on the left), and what I actually need (on the right). I've tried CTRL+SHIFT+V but it doesn't work either. I did it in the past, but can't remember how.



copy+paste comparison










share|improve this question









New contributor




maicart is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











I've googled this issue and have found plenty of information on how to "split text into different columns", but I want to copy+paste the text into just one column on the google sheet.



Herewith is a picture that shows what I'm getting (on the left), and what I actually need (on the right). I've tried CTRL+SHIFT+V but it doesn't work either. I did it in the past, but can't remember how.



copy+paste comparison







google-sheets






share|improve this question









New contributor




maicart is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question









New contributor




maicart is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question








edited 2 days ago









Yannick Loriot

5,92022545




5,92022545






New contributor




maicart is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked 2 days ago









maicart

1




1




New contributor




maicart is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





maicart is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






maicart is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.












  • Paste it in notepad first may work
    – roozbeh S
    2 days ago


















  • Paste it in notepad first may work
    – roozbeh S
    2 days ago
















Paste it in notepad first may work
– roozbeh S
2 days ago




Paste it in notepad first may work
– roozbeh S
2 days ago

















active

oldest

votes











Your Answer






StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});






maicart is a new contributor. Be nice, and check out our Code of Conduct.










 

draft saved


draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53238455%2fhow-can-i-copypaste-rich-text-to-just-one-column-on-google-sheets%23new-answer', 'question_page');
}
);

Post as a guest





































active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes








maicart is a new contributor. Be nice, and check out our Code of Conduct.










 

draft saved


draft discarded


















maicart is a new contributor. Be nice, and check out our Code of Conduct.













maicart is a new contributor. Be nice, and check out our Code of Conduct.












maicart is a new contributor. Be nice, and check out our Code of Conduct.















 


draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53238455%2fhow-can-i-copypaste-rich-text-to-just-one-column-on-google-sheets%23new-answer', 'question_page');
}
);

Post as a guest




















































































Popular posts from this blog

Full-time equivalent

Bicuculline

さくらももこ