About 1,523,127 results (4,118 milliseconds)
How to add multiple cells in one cell - Google Docs Editors Community
https://support.google.com/docs/thread/180701721/how-to-add-multiple-cells-in-one-cell?hl=en Sep 23, 2022 ... The correct method is to create narrow columns. Each of the narrow columns will appear as smaller cells. Then you select 5 cells above and merge those cells.
Change multiple cells based on one cell - Google Docs Editors ...
https://support.google.com/docs/thread/158571517/change-multiple-cells-based-on-one-cell?hl=en Apr 5, 2022 ... But if I14=Yes then I need those cells to still calculate the number of days between dates. I tried to use an IF formula but I couldn't make it ...
Multiple Links in One Google Sheets Cell - Google Workspace ...
https://support.google.com/a/thread/45130142/multiple-links-in-one-google-sheets-cell?hl=en May 8, 2020 ... ... a range of cells to link". 4) Navigate to and click on the cell ... I was able to create multiple links in the same cell after doing that.
How can I merge two cells in Sheets and keep contents of both cells ...
https://support.google.com/docs/thread/52208798/how-can-i-merge-two-cells-in-sheets-and-keep-contents-of-both-cells-with-a-comma-in-between?hl=en Jun 8, 2020 ... I would like to merge these cells into one cell, and add a comma between them (ex: Doe, John). How do I do this easily without losing the contents of the 2nd ...
Combine phrases in multiple cells into one cell, removing duplicate ...
https://support.google.com/docs/thread/6047360/combine-phrases-in-multiple-cells-into-one-cell-removing-duplicate-phrases?hl=en May 13, 2019 ... I am trying to consolidate a list of fish that spans multiple cells into one cell. The final cell should include all of the names of the fish, but also remove ...
Can you enter multiple data in one cell and parse them separately ...
https://support.google.com/docs/thread/7671180/can-you-enter-multiple-data-in-one-cell-and-parse-them-separately-when-referencing-the-cell?hl=en Jun 8, 2019 ... The idea is to have multiple data points per cell (if easily possible) which can then be parsed by formulas referencing said cells so we can tally points over ...
Hey! I'm looking for the way to split a cell into two cells as shown in ...
https://support.google.com/docs/thread/60404008/hey-i-m-looking-for-the-way-to-split-a-cell-into-two-cells-as-shown-in-my-post?hl=en Jul 22, 2020 ... To split cells, open a Doc > right-click the cell > click Split cell > enter the number of rows and columns you want > click Split.
How to convert one cell with multiple values into one cell with one ...
https://support.google.com/docs/thread/11986742/how-to-convert-one-cell-with-multiple-values-into-one-cell-with-one-value?hl=en Aug 15, 2019 ... Is there any way to convert multiple values in one cell into one value per cell? I tried using "split text into columns" function but it doesn't work with some ...
How do you split a cell? - Google Docs Editors Community
https://support.google.com/docs/thread/10152381/how-do-you-split-a-cell?hl=en Jul 18, 2019 ... You might want to split a cell into two smaller cells within a single column. Unfortunately, you can't do this in Excel. Instead, create a new ...
IMPORTRANGE pulling from multiple columns into one column ...
https://support.google.com/docs/thread/201258169/importrange-pulling-from-multiple-columns-into-one-column?hl=en Feb 9, 2023 ... I am trying to combine the two inputs in a different google sheet into one column/cell. I was able to use the below breakdown to get the information for a ...
Is there a way to paste multiple lines of text into one cell and keep ...
https://support.google.com/docs/thread/221785335/is-there-a-way-to-paste-multiple-lines-of-text-into-one-cell-and-keep-the-formatting?hl=en Jun 20, 2023 ... You can paste the first line of text into a cell then click CTRL+ENTER and it will let you paste a second line then rinse and repeat.
How to combine two cells with text and a date? - Google Docs ...
https://support.google.com/docs/thread/78157004/how-to-combine-two-cells-with-text-and-a-date?hl=en Oct 20, 2020 ... I am trying to combine two cells, one with “As at” and the other cell is a date “21-Oct-2020” My formula is =B1&" "&B2 , however, the result comes up ...
Import multiple cells(sheets) into single cell - Google Docs Editors ...
https://support.google.com/docs/thread/210156006/import-multiple-cells-sheets-into-single-cell?hl=en Apr 8, 2023 ... I have 5 work sheets(different people) all with same main data but each person making different comments. How do I go about importing from the ...
Apply two conditional formatting rules simultaneously in Google ...
https://support.google.com/docs/thread/13813522/apply-two-conditional-formatting-rules-simultaneously-in-google-sheets?hl=en Sep 7, 2019 ... How can I apply both without one rule cancelling out the other? At the moment, I can only give cell D2 a light green background or dark blue ...
Is there a way to make rows with multiple lines of text only show a ...
https://support.google.com/docs/thread/240451229/is-there-a-way-to-make-rows-with-multiple-lines-of-text-only-show-a-single-line-of-text?hl=en Oct 23, 2023 ... The only other option I can think of would be to make the columns that tend to get more than one line of text their own row below the other rows ...
Function to Combine Data in Multiple Cells on one Sheet to a Single ...
https://support.google.com/docs/thread/12617867/function-to-combine-data-in-multiple-cells-on-one-sheet-to-a-single-cell-on-another-sheet?hl=en Aug 23, 2019 ... I'm familiar with formulas in Excel, just not these. The first tab is the way I'd like the info to be. Hoping there's a formula instead of doing ...
Chaining 2 cells together so they both move when new data is ...
https://support.google.com/docs/thread/122783863/chaining-2-cells-together-so-they-both-move-when-new-data-is-entered-not-at-the-bottom?hl=en Aug 24, 2021 ... However, a problem occurs if we make an old customer, a current customer. ... one formula in cell A2: =ArrayFormula('current students'!B:D). I ...
How do I concatenate and copy text from two adjacent cells ...
https://support.google.com/docs/thread/4895603/how-do-i-concatenate-and-copy-text-from-two-adjacent-cells?hl=en Apr 25, 2019 ... ... take one formula which I put in C2 of your Counts sheet. Here is that formula. =ArrayFormula(IFERROR(VLOOKUP(A2:A,{Responses!E2:E,Responses ...
How can I import multiple cells from one spreadsheet to another ...
https://support.google.com/docs/thread/173705377/how-can-i-import-multiple-cells-from-one-spreadsheet-to-another-spreadsheet?hl=en Aug 3, 2022 ... ... another spreadsheet, and I followed the ImportRange and sheet name and cell number. But I need to do manually for each cell, how do I make ...
Combine cells into one cell with line breaks - Google Docs Editors ...
https://support.google.com/docs/thread/157314891/combine-cells-into-one-cell-with-line-breaks?hl=en Mar 26, 2022 ... I want a list of the chosen courses per student in column Z. I tried that with two formulas, like in cell Y2 or in Y3. But: - I get a lot of extra line breaks.