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.
May 8, 2020 ... I have been working in a master list of materials and want to navigate between specific items within one of the groupings, in this case, Jacks, Faceplates & ...
Apr 5, 2022 ... I have a section of cells that calculate the number of days between those dates. But if the form is complete when I receive it then I need those cells to show ...
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 ...
Aug 3, 2022 ... ... 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 it ...
May 13, 2019 ... I want to have a list that removes the duplicate instances of Black Cod. I've tried using the textjoin function, (=textjoin(", ",True,A3:D3)) ...
Jan 15, 2025 ... I have these documents working fine in Excel but a new person with whom I need to share cannot handle Excel and I need to put on Sheets so I can ...
Aug 15, 2019 ... If you don't add as many columns as the greatest number of numbers you have in a cell and used only 1 column with the formulas then the sheet ...
Jun 20, 2023 ... I have a source document with formatted text over multiple lines. I want to be able to select the multiline text and paste it into one cell ...
Jul 16, 2021 ... All of that will go into ONE cell. I would like to extract just the specific, "Exam" and "Teacher Name". Right now the data being put into that ...
Aug 23, 2019 ... I have to publish all of the volunteers scheduled that week sorted by the different times each week. So I'm trying to find a way to basically ...
Apr 8, 2023 ... How do I go about importing from the same cell on each of those 5 work sheets into a single master worksheet(cell) that only I can view and ...
Nov 5, 2019 ... I have a 2 google worksheets. Worksheet 1 with sheet 1A and Woksheet 2 with sheet 2A. These two sheets has a column with same value (ID) in ...
Feb 25, 2021 ... I want to be able to have all the COUNTA ranges that I have be added together into one cell. ... The total amount of cells that can have data in ...
Apr 23, 2023 ... ... one cell at a time. Is there a way to split multiple cells at once so I don't have to do each cell individually? ... Google Docs does not have ...
Apr 17, 2019 ... I have tried selecting multiple cells and pasting using a right click, ctrl V, and the edit file. I have looking anywhere I can but I have found nothing to ...
Jan 29, 2021 ... But these locations are pulled from another sheet where the "location" values are in ONE cell ( i can't put in separate cells as each row ...
Jul 18, 2019 ... That will separate text in a single cell into multiple cells based on a delimiter, very similar to Excel's "Text to Columns" feature. You can ...
Aug 9, 2019 ... ... cell E4 and have the total of both of these cells imported into ONE cell in workbook 2. If I IMPORT range E1:E4 it also combines the total ...