About 1,495,130 results (3,984 milliseconds)
Is it possible to combine (merge) two columns in a google sheet ...
https://support.google.com/docs/thread/33449662/is-it-possible-to-combine-merge-two-columns-in-a-google-sheet?hl=en Mar 13, 2020 ... 3) I ... I put the IF in there so that if you don't have a name it won't put in a bunch of cells with just the commas and spaces (", , " ).
Adding a " " space to an ArrayFormula w/ a Concatenation - Google ...
https://support.google.com/docs/thread/113328378/adding-a-space-to-an-arrayformula-w-a-concatenation?hl=en Jun 12, 2021 ... The space would be the third. The CONCATENATE() function does ... I entered the formula into cell J1 in your spreadsheet. ={ "Result ...
Best way to combine multiple cells (some blank) - Google Docs ...
https://support.google.com/docs/thread/177547432/best-way-to-combine-multiple-cells-some-blank?hl=en Sep 1, 2022 ... I've got a scenario where I'me trying to join multiple columns which I can do with "=ArrayFormula(concatenate(A2:I2&" > , "))".
Large space that I cannot delete in my document! - Google Docs ...
https://support.google.com/docs/thread/6485484/large-space-that-i-cannot-delete-in-my-document?hl=en May 20, 2019 ... 2. Drag your cursor through a couple of sentences that are set up the way you want them, with the font and line spacing you prefer. 3.
Merging form answers from different sections into the same column ...
https://support.google.com/docs/thread/95751354/merging-form-answers-from-different-sections-into-the-same-column-for-a-linked-spreadsheet?hl=en Jan 29, 2021 ... I have given you another option that will help eliminate the white space. ... three columns like: Sheet1!A1 - Sheet1!B1 - Sheet1!C1. Sheet1!A2 ...
GoogleSheets: Take data in separate cells and combine into 1 cell ...
https://support.google.com/docs/thread/80623259/googlesheets-take-data-in-separate-cells-and-combine-into-1-cell-separated-by-commas?hl=en Nov 2, 2020 ... ... column - one above the other) - and show those item numbers in another cell (on the same tab) separated by a comma and space. I've worked ...
Consolidate multiple columns of data into one column in a new tab ...
https://support.google.com/docs/thread/79821686/consolidate-multiple-columns-of-data-into-one-column-in-a-new-tab?hl=en Oct 29, 2020 ... E.g. If a new name is added in the TeamList beginning with G, it will populate to my new tab in the middle of the list, but with a blank space ...
Combining multiple columns without leaving gaps - Google Docs ...
https://support.google.com/docs/thread/107324128/combining-multiple-columns-without-leaving-gaps?hl=en Apr 23, 2021 ... I have three columns of information that I need to combine into one column so it can be used for a dropdown list. Currently, I'm using this formula, but there ...
Concatenate + remove duplicate data in multiple columns for every ...
https://support.google.com/docs/thread/157888924/concatenate-remove-duplicate-data-in-multiple-columns-for-every-value-that-matches-in-column-a?hl=en Mar 30, 2022 ... Concatenate + remove duplicate data in multiple columns for every value that matches in Column A ... Cell I3: =join(", ",unique(filter(SOURCE!D:D, ...
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 ... This formula will join the comments in cells A1 to A5 with a comma and space as a separator. Note: You may need to adjust the formula based ...
Add and edit tables - Computer - Google Docs Editors Help
https://support.google.com/docs/answer/1696711?hl=en&co=GENIE.Platform%3DDesktop You can move rows and columns or merge cells together. In Google Docs, if you have large tables that cross multiple pages, you can also pin header rows at ...
If function, CONCATENATE, and a line break in between two blocks ...
https://support.google.com/docs/thread/24891189/if-function-concatenate-and-a-line-break-in-between-two-blocks-of-text?hl=en Jan 6, 2020 ... Hi everyone - sheets/excel novice here. Is it possible to pull ... spaces) between two cells of text. I have a form being used for an ...
How to insert an image into a cell, but also have it expand larger/orig ...
https://support.google.com/docs/thread/227646659/how-to-insert-an-image-into-a-cell-but-also-have-it-expand-larger-orig-size-when-you-click-on-it?hl=en Jul 27, 2023 ... I need to insert an image, possible multiple images into cells on each row. ... space that the 'Insert Image over Cell' does. Insert -> Image ...
Remove line above table - Google Docs Editors Community
https://support.google.com/docs/thread/32571948/remove-line-above-table?hl=en Mar 6, 2020 ... There isn't any way to remove the line space completely. If you're trying to combine two tables -- per your other post -- that currently isn't ...
Google Docs Splitting Tables Across Pages - Google Docs Editors ...
https://support.google.com/docs/thread/41933766/google-docs-splitting-tables-across-pages?hl=en Apr 23, 2020 ... I have to go back ground and find any split tables and delete the added space. This used to evenly split the table across all cells OR push the full table to a ...
Merge multiple line from many rows into one cell, add comma ...
https://support.google.com/docs/thread/152626698/merge-multiple-line-from-many-rows-into-one-cell-add-comma-separator-and-line-break?hl=en Feb 28, 2022 ... If the source data contains spaces, they will get replaced with commas. That can be avoided with additional substitute() functions. If you ...
How can I delete a section break in Google Docs. The backspace ...
https://support.google.com/docs/thread/3822385/how-can-i-delete-a-section-break-in-google-docs-the-backspace-key-will-not-delete-the-section?hl=en Apr 8, 2019 ... Also if you create columns, but they only apply to parts of the ... Oct 3, 2019. 10/3/2019, 9:57:16 AM. Get link.
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 person who's been managing our spreadsheet has been combining both stages into a code for people to see what they missed (e.g. missed 1 from ...
How to remove unwanted spaces - Google Docs Editors Community
https://support.google.com/docs/thread/188915830/how-to-remove-unwanted-spaces?hl=en Nov 16, 2022 ... I will be copying multiple strings, up to 50 characters, for hundreds of students. ... For example these will remove all spaces from cell A1 (and ...
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 ... ... cells when pulling the data so there wasn't any space. ... I'm trying to combine (using CONCATENATE) two columns into one in the other google ...