10
votes
Accepted
How to use "split text to columns" when pasting in Google Sheets?
I took some test CSV data and pasted it into a Google Sheet. When I opened the clipboard and chose "split text to columns", my data was immediately split. There shouldn't be anything else you need to ...
- 52.3k
9
votes
Accepted
How can I copy all events from one calendar to another?
If the other calendar is shared with you and available in the "Other Calendars" section in Google Calendar, you can save the ICS version of the calendar and import that into your own.
To do ...
- 1,339
6
votes
Accepted
5
votes
Copy Date Value and Paste as actual Date not number
You would use the text function.
If you have =today() in A1, you would use =text(A1,"mm/dd/yyyy"). (There are multiple formats for 'mm/dd/yyyy' if that's not the format you want.)
Alternatively you ...
- 533
4
votes
How to copy-paste information from one drawing to another one in draw.io
I was able to do this using the scratchpad feature on the left-side menu. In the 'source' diagram, I dragged the component I wanted to copy into the scratchpad, then I opened the 'target' diagram and ...
- 141
3
votes
What is the best way to paste code into a Trello card?
In 2020, wrapping a code block in ``` (triple backticks) in Trello still drops newlines, etc.
I have to add 4 spaces before each line to get it display lines and indentation properly. Thanks @GiH for ...
- 131
2
votes
What is the best way to paste code into a Trello card?
I know that the subject is a bit old, but I found myself faced with this problem.
I wrote an userscript if anyone is interested in it.
It works with triple backslash with line feed and allows syntax ...
2
votes
Pasting with colours and formatting Google Document
Without a sample from Visual Studio 2013 (in Microsoft Windows 8) to hand, I can't be sure but believe enhancements to Docs since OP was posted have changed the circumstances upon which the question ...
- 17.4k
2
votes
Paste hyperlink formulas but replace cell references with the actual values from the referenced cells
I had the same issue and found a solution.
Copy the column from your spreadsheet.
Paste the column into a Google Docs document (not Google Sheets) without linking.
Copy the column from the document ...
- 21
2
votes
Accepted
What is a cut and paste approach to converting a chunk of a google spreadsheet to markdown table?
Actually the answer is trivial: Google webapps has
MarkdownTableMaker
https://chrome.google.com/webstore/detail/markdowntablemaker/cofkbgfmijanlcdooemafafokhhaeold?hl=en
Works reasonably well.
2
votes
Accepted
Where is Excel's Paste Special Operations in Google Sheets?
There is no such thing in Google Sheets. All you have in Google Sheets is this:
- 26.2k
2
votes
Accepted
How to format clipboard text as data row in Google Sheets?
Most likely you are looking for direct transposed paste which is supported in Google Sheets via keyboard shortcut combo:
LEFT ALT + E + S + E (for Windows+Chrome)
CONTROL + OPTION + E + S + E (for ...
- 26.2k
2
votes
Accepted
Pasting text without interpreting as formula
You can copy paste the data in a tab free of data in column A.
Then in column B1 you can use this :
=REGEXREPLACE(formulatext(A1),"=",)
Copy the cell for every data you have in column A
Copy ...
- 1,968
2
votes
Copy/multiply cell contents based on number in another cell
Here is another approach:
=ArrayFormula(VLOOKUP(TRANSPOSE(SPLIT(JOIN("",REPT(ROW(A:A)&"@",A:A)),"@",0,1)),{ROW(A:A),B:B},2,FALSE))
How It Works
=ArrayFormula(...) ...
- 4,980
2
votes
Accepted
Copy/multiply cell contents based on number in another cell
Please use the following
=QUERY(ArrayFormula(flatten(IFERROR(SPLIT(REPT(B1:B&"@",A1:A),"@")))),"where Col1<>'' ")
How the (undocumented) flatten function work.
...
- 12.6k
1
vote
How do I paste formulas from a plain text file into a Google Sheet?
I solved my problem. Copy and paste without doing anything special at all works just fine.* The reason that was not working for me initially is that inadvertently the cells I was pasting into had ...
- 21
1
vote
Accepted
How does Google Spreadsheet preserves formatting in external Copy-Paste?
What you are seeing is most likely a Google Sheets optimization side effect. Google Sheets has its own web clipboard that kicks in when you copy one or more cells in a spreadsheet.
To avoid that, use ...
- 13.2k
1
vote
How to copy text in a table cell in Notion?
The easiest solution is to change the way you are pasting. On Windows try pasting as Ctrl + shift + V instead of Ctrl + v -- this should paste the values only.
- 11
1
vote
How to copy formulas from one spreadsheet to another?
I know this is a few years after the initial question, but I found a quick(ish) workaround that requires a couple steps outside of google sheets..
I tried the 'Show formulae' method as this was a good ...
- 21
1
vote
Create a hyperlink from two columns, one with title and one with links, then retain only the hyperlink without losing the references
setFormula is not available within a custom function.
One of the workarounds suggested (by Google) is to use onEdit(e) instead of a custom function. Unbelievably, they don't regard this workaround ...
- 5,520
1
vote
Google Sheets on PC Copy/paste using "Paste Values" (Crtl+shift+V) appears to work but numbers are not treated as numbers in GRAPHS
Try CTRL + SHIFT + V followed by CTRL + \.
This should reset the formatting from whatever back to Automatic.
Or use straight this combo:
CTRL + SHIFT + V
LEFT ALT + O
N
N
- 26.2k
1
vote
How to prevent cut-and-paste data from changing collapsed grouped cells?
Not really possible to prevent this from happening in Google Sheets, but there are always ways with formulas...
=ARRAYFORMULA(REGEXREPLACE(TO_TEXT(COUNTIFS(IFERROR(REGEXREPLACE(
REGEXEXTRACT(A1:A, "^...
- 26.2k
1
vote
Is there a way to add a "Copy to clipboard" button in a Google Doc?
Use Google Apps Script to add a custom menu with your button or an option to open a sidebar/dialog that holds your button.
You can even publish your script as an add-on so the button will be ...
- 44.6k
1
vote
How can I copy all events from one calendar to another?
An embedded (or embeddable) calendar will have some possibly very long URL starting with
http://www.google.com/calendar/embed?
Within the possibly very long URL, you will find one or more parts of the ...
- 111
1
vote
Copying Cell Color from Conditional Formatting
There does not seem to be one from the Sheets UI.
The script editor has the ability to get a cell or cells color irrespective of whether it is conditional formatting or manual, with getBackground() ...
- 527
1
vote
Accepted
Why doesn't my onEdit Function behave the same as my onFormSubmit
After spending every waking moment working on this and now much more since I have answered this question and I m sorry it took a while to update. here's where I have left off. it's clunky but ...
1
vote
Copying cells in Google Spreadsheets and pasting into text file adds quotes around each cell
Copy of a Comment by Alexander Taylor Oct 27 '15 at 22:34 :
i notice that it only happens when cells contain newlines and possibly other special characters. adding the quotes might be done by the ...
1
vote
How to copy-paste information from one drawing to another one in draw.io
As of 11 November 2020, I have found the following solution.
Software used: Diagrams.net 13.7.9
Solution Summary: Using mouse controls to select, copy, from source drawing and paste into new drawing ...
Only top scored, non community-wiki answers of a minimum length are eligible