If you wish to concatenate two or more cells separated by spaces in Google Sheets, use the following formula: =A2&" "&B2. Small errors. CHOOSE is a bit strange; for whatever reason, in the newest version. I need to join all cells that are dependent of another cell, separating it by comma. google-sheets; concatenate; google-sheets-filter; or ask your own question. The first argument you put is cell A2, where the first name is stored. With the TEXT () function, we can convert the date into the date format we prefer. google-sheets; or ask your own question. Select the range of cells that you want to concatenate with line break, and then click Kutools > Merge & Split > Combine Rows, Columns or Cells without Losing Data, see screenshot: 2. . Next, we need to split that huge list so that we get all our values in their own cell. 0. 3. Google Sheets - Concatenate 2 rows across columns into 1 cell. We use the following formula for achieving this: =CONCATENATE ("Birthday: ",TEXT (A9 ,"dd/mm/yy")) The TEXT () function accepts two arguments: the date/number to be formatted and the format to use. In the column where you want the full names, type the TEXTJOIN function. value2 – the value to join. Type the address of the other column that you want to combine with, such as B1:B. Google Sheets - How to concatenate cells that meet a condition. In Google Sheets, you can use the delimiters to split the text. That is, CONCATENATE(A2:B7) is equivalent to CONCATENATE(A2,B2,A3,B3. To combine columns horizontally in Google Sheets, follow these steps: Type =ARRAYFORMULA ( to begin your formula for combining columns. The second argument is B2 that consists of the last name. For example: =C2&”_”&D2. Now see the below CONCATENATE formula. =textjoin(", ",true,A:A) Share. In Columns H, I, J, it will gather the data in the cells within specified ranges and concatenate them for easier reading at a glance. Search. In our case, we selected Cell D5. I am trying to make life easier for myself by organising my teaching materials for private tutees of mine from various subjects/educational levels in google spreadsheets. The ampersand (&) is Excel's concatenation operator. Type a formula to merge the first cells in each column (most likely, these will be cells from row 2 unless your dataset doesn’t have a header row). Now I get [the entire list of FILTER 1, the entire list of FILTER 2] when I need [FILTER 1 result 1,FILTER 2 result 1] and so forth. The CONCAT function combines the text from multiple ranges and/or strings, but it doesn't provide delimiter or IgnoreEmpty arguments. There are 5 more helpful options for you to merge values in your sheet: Choose to Insert new row/column with the results to place additional cells with the joined values next to your original data. Note: This feature is available on Windows or Mac if you have. The syntax for the TEXTJOIN formula in Google Sheets is as follows: =TEXTJOIN (delimiter, ignore_empty, text1, [text2,. Enter the CONCATENATE function - =CONCATENATE (Cell1, “ ”, Cell2, “ ”, Cell3. See the later section on this topic. Step 4. Step 3: Now enter the delimiter in “”. Combine two or more cell; Combine multiple columns into one single column; Combine two or more cells and transpose; Combine data from multiple Google Sheets tabs and get sheet/tab name; Others Formulas. Clear searchFire up your browser, open up a Google Sheets document, and select all the cells you want to split up. best wishes. 16. Wrap the formula in ARRAYFORMULA, editing the data ranges to cover the entire columns. =IF (AND (NOT (ISBLANK (W2)),NOT (ISBLANK (AA2))),CONCATENATE (H2,"-",AA2),"") It Concatenate me the cells because i guess W2 and AA2 have some Array formulas. Google Sheets / Excel - Create a minimum list based on multiple cells. IZQUIERDA (LEFT). Follow these steps: Step 1: Open your Google Sheets document. " You can’t put quotes inside quotes, as you’ve already found out, because it’ll break the formula. Appends strings to one another. The. Here’s how it works. In a blank Google Sheets, in cell A1 enter the text Hello. The second argument is B2 that consists of the last name. The custom number format editor window looks like this: You type your rule in the top box and hit “Apply” to apply it to the cell or range you highlighted. So, if you have first names in one column or row and last names in another, yo. This video shows you a useful trick that we frequently use in data analysis projects: How to surround words by quotes and separate them by commas using googl. Then, select an individual's first name (e. Utilize the CONCATENATE formula with cell references and commas: =CONCATENATE (B2, ", ", A2). This will enter the column and row cell reference for the first name into the formula. 2. In the. Excel Function to Concatenate & Exclude Zeros. Result. How to Use TEXTJOIN Function in Google Sheets. Use LEFT FunctionThis help content & information General Help Center experience. Returns the concatenation of two values. Step 1: Identify the text values you want to concatenate. If the desired cell has been referenced in the formula, then enter ," ",. If you have ever tried to combine columns in Google Sheets only to find that the data has been merged together in one column instead of two, you are not alone. . g. You could specify the cells with an ampersand in between. = CONCAT ( A2, B2 ) To use this function to combine the first and last names insert the above formula into cell C2. In Excel, you can use the "&" operator to combine different text strings or cell values. Step 1: Start with the innermost SPLIT function to separate items in the rows with multiple items: =SPLIT (A2:A100,",") We’re telling the SPLIT function to separate items based on the commas. Can I get 1. Hold ALT + F11 keys on the keyboard to open a Microsoft Visual Basic for Application. Using the Ampersand Symbol to Concatenate with Separator in Google Sheets. Notes. UNICODE function. Google Sheets formula to combine data in columns in columns A, B, and C to a single list in column D:=FILTER (. What can I do to get it to the ignore blank cells?. Read more about syntax differences in your formulas. Concatenating two columns horizontally in Google Sheets allows you to merge the data from two separate columns into one, with the data presented horizontally for each row. This allows you to combine text within multiple cells together. Step 3. –3, separated by a comma and a space. In this example, we use the concatenating operator (&), but you could also use the CONCATENATE Function: "=CONCATENATE (C3,D3)" Once you have the helper. Case 3: Combine Duplicate Cells. Delimiter: the special character in the data to use as markers for splitting it to columns; they are closed in double quotes. Here we use the CONCATENATE function but use the same way to combine values. )Add a Formatter Text action to your Zap, select the Replace transform, and tell Zapier what text you want to search through. Find answers from experts and other users in the Google Docs Help Community. In the Combine Columns or. Click on any cell to make it the active cell. It is available in Excel 2016 and above. Finally, close the formula with a parenthesis and press enter. Example 3: Extract Numbers from Text. So, the steps will be the following: 1. ; Combine necessary cells of data together Concatenate records from the selected range into one cell. 3. ) and whether to ignore blank values. In this comprehensive guide, we will explore the CONCAT formula in Google Sheets. However,. I have a range of values and empty cells A2:F15 I want to concatenate only non empty cells using a single formula Arrayformula, Make a copy of this example sheet. This tutorial demonstrates how to use the TEXTJOIN Function in Excel and Google Sheets to combines text from multiple strings. First, enter “=”. So, all you need to do to make the formula work with the other cells is drag it downward. If standard ways of Google spreadsheets to combine data from multiple sheets seem dull, and the functions scare you off, there's an easier approach. The CONCATENATE function is designed to join strings together. Ablebits blog; Google Sheets Tips;. Here's how to:Select the cell you want to insert the line break. This help content & information General Help Center experience. Add-ons for Google Sheets Add-ons for Google Docs. Access custom number formats through the menu: Format > Number > Custom number format. To use the Concatenate function, firstselect the cell where the combined data will be placed. Saiba como trabalhar nos arquivos do Office sem instalar o Office, criar planos de projetos dinâmicos e agendas de equipe, organizar automaticamente sua Caixa de entrada e muito mais. Google has that feature built-in. Step #1: Open the Google Sheet . Other useful Excel and Google Sheets to combine cells and columns data. Update May 2021. CONCATENATE function. When a range with both width and height greater than 1 is specified, cell values are appended across rows rather than down columns. Using commas (Last Name, First Name) offers more flexibility when it comes to separating names in Google sheets. With double quotation marks, specify a comma and a space, like “, “. This happens because QUERY assigns a data type for each column based on a sample of each column data. it is with my production sheet which contains 6K rows. Steps: Firstly, select a cell where you’ll apply the formula to concatenate double quotes. Is there a workaround this ?In Google Sheets, just like a comma, you can use any separator to concatenate two or more values. 0. Tap on a cell within the cell range that you wish to merge. In many cases, the values in the source string are separated by a sequence of characters, a comma and a space being a typical example. +-----+ | Labels | +-----+ | Foo,Bar | | Bar,Baz | | Quux,Quuz | I want to create a formula that generates a a column with all the unique labels separately in a row. The JOIN function simplifies combining a list of values in separate cells into a single cell separated by an appropriate delimiter. Just put a comma between the Query formulas. For example, say you have a list of first names and last names, and you want to combine them to get the full name in one cell. Given the sheet:Let’s start with a very simple row array example: The formula to create this array, in A1, is: = { 1 , 2 , 3 } The opening and closing curly brackets denote the array. A cell can contain 1 or more labels, each separated by a comma. Step 3: In the window, drag and drop the file or click on the. Función CONCATENAR (CONCATENATE) 8 de 43. ]) string1 - The initial string. ) Select the combine type under the To combine selected cells according to following. Separate each cell with a comma. Você está usando os produtos do Google, como o Documentos Google, no trabalho ou na escola? Consulte dicas, tutoriais e modelos úteis. Type the CONCAT function and select the cell with the first string. First, enter the TEXTJOIN function in a cell. Sometimes you may need to combine text from two different cells in a spreadsheet. Share. Your formula should look like this: To use CONCATENATE in Sheets, click and select the cells you wish to combine. Again enter the ampersand and refer to the last name. =transpose (split (textjoin (", ",1,I2:I16),"|")) This way we can remove duplicates from comma-delimited strings in Google Sheets. 2. ‘. Click Kutools > Merge & Split > Combine Rows, Columns or Cells without Losing Data, see screenshot:. CHAR; 5 of 43. For example, say you have a list of first names and last names, and you want to combine them to get the full name in one cell. Here is an image. However, if you are setting the value via an action, it will not add the single quote. TEXTJOIN. This time, we'll still update cells but will also pull other related columns and non-matching rows. 0. The following step-by-step example shows how to use this option to add commas to a number in Google Sheets. Step 3: Create the CONCATENATE Formula. Goal: I'm using QUERY () in gSheets to combine data from multiple sheets in the same workbook. In our example, we can use it to combine the text in column A and column B to create a combined name in a new column. Note: Google Sheets users can use the TEXTJOIN Function, but have a slightly different way of entering array formulas. Choose where you want to place the result. Clear searchFortunately, the solution is simple! We just combine LEFT and RIGHT with either the FIND or SEARCH functions. Next, type the equal sign = to begin the function, followed by ARRAYFORMULA and an opening bracket (. You only need to change the range in the above formula on your Sheets. Type in the argument, which is ROW ()-1. Trend Linkedin-in Youtube. Also, check the Google Spreadsheets function list (search for FILTER ). IGUAL (EXACT) 10 de 43. Modified 3 years, 6 months ago. Well. CONCAT replaces the CONCATENATE function. Step 5. Join a list of values into a single cell. Let’s use the below Query in the. Enter the starting. March 4, 2022 by Zach Google Sheets: How to Use CONCAT with QUERY Often you may want to concatenate the results of a query in Google Sheets into one cell per row. You should see a small box on the bottom right-hand corner of. Here is another way to do it in Google Sheets: If A1 = Hello" World. First, enter the TEXTJOIN function in a cell. Yes, by FILTER ing the array: = JOIN ( " vs " ; FILTER (C10:C14; NOT (C10:C14 = "") )) Thus, the JOIN method will only operate on non-empty cells. For example, if you have the first name in cell A2 and the last name in cell B2, you would enter the formula =mergeNames (A2, B2) in cell C2. That lead to Google Sheet treating the cell as a formula. For example, to combine the text strings “First Name” and “Last Name” into a. Then tell the Zap what you want to find—anything from text to spaces to line breaks. Concatenate If in Google Sheets. Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts. The strings can be text, numbers, or single-cell references. Once you press enter, the column should autofill with the combined names, as seen below. Step 4. Combine multiple email addresses (in separate cells) into one cell (separated by comma) Google Sheets or Excel 1 Get unique list in a column from values separated by commas in different rowsConnect your Google Sheet with the columns of CCs/BCCs. This will open a new window. 7. See full list on howtogeek. CODE; 7 of 43. To be precise, we have used a comma and whitespace as the separator. =TEXTSPLIT(A2, ", ")Supposing you have a list of full names in column A and want to extract the first name that appears before the comma. Method 4: Combining cells in Google Sheets with a separator (comma/space) There are several instances when you need to combine cells in Google Sheets. This is a common problem that a lot. In this case a “space”. For example, you may have a first name and last name in separate columns, and you want to combine them into one column. Step 4: Customize the CONCATENATE Formula. ; Determine a place for results Get the results in a new row or extra column, or add them to a certain cell within the selected range. Step 2: Press “=” and type JOIN. Method 4: Combining cells in Google Sheets with a separator (comma/space) There are several instances when you need to combine cells in Google Sheets. Suppose I have entered $2,500. These could be singular or have multiple themes in the cell separated by a comma. How to CONCATENATE in Excel (Step-By-Step) - CONCAT & String. Separate each value with a comma. In the example above, within the TEXTJOIN Function we first enter the comma as the. September 12, 2022 • Zakhar Yung Cell A1 contains “ Jane “, cell B1 contains “ Pontiac “, and cell C1 contains “ 1970 “. Google Sheets CONCATENATE with comma. Combine First and Last Name Example. Since we are inputting the separators as text, it can take any form. Here, the dataset represents the sale of the current month in different companies. Reverse Last Name & First Name With Comma Using One Formula: Google Sheets September 24, 2021. The first cell will contain the sum of A1 to A10, the cell to the right will contain the sum of B1. Either type in the word ArrayFormula and add an opening/closing brackets to wrap your formula, or, more easily, just hit Ctrl + Shift + Enter ( Cmd + Shift + Enter on a Mac) and Google Sheets will add the ArrayFormula wrapper for us. Step 3. To filter by using the FILTER function in Google Sheets, follow these steps: Type =FILTER ( to begin your filter formula. How to. SORT sorts a vertical array, 1 = single column and FALSE reverses the order. To get around that problem, you can create a fourth column with a function that adds a comma to the end: There is a problem with an extra comma on the end, which you can get rid of. Now, click on Data in the top bar and then click on the Consolidate button in the Data Tools section. Here, we’ll combine two columns in Google Sheets by utilizing the CONCATENATE function. Google Docs Editors Help. The Excel concatenate multiple cells with comma (without the TEXTJOIN function) template below relies on several cells (1 cell for each original cell you concatenate). Using Google products, like Google Docs. =TEXTJOIN (", ",TRUE,A2,B2,C2) The Address column in the table above was created using the TEXTJOIN function. Sample Usage CHAR (97) CHAR (HEX2DEC ("A3")) CHAR (A1) Syntax CHAR (table_number) table_number. Navigate to the bottom of the menu to. I have provided an example below: Column A and Column B make up the search range, and Column C contains the search keys. We can do this by applying a custom number format. The problem is that it's including a comma between the date and time which means Google Sheets won't read it as a date. To extract the text before the comma, we can use the LEFT and FIND functions. Originally Posted by AliGW. It works the same for the “0” or “#” notation:This help content & information General Help Center experience. How to Insert a New Line in a Cell in Google Sheets - Place Cursor. This is a true array, insofar as Array. Note: The TRUE argument specifies that blank cells in the range should be ignored. We normally use Comma or Semicolon as the delimiter. Combine Two Columns in a Third Column. The Concatenate function is a powerful tool in Google Sheets that allows users to combine text strings, numerical values, dates, times, and other data in a single cell. When you pass a range to a custom function in Google Sheets, the range comes in as an array of arrays. Ok, that’s better! We just used the Ampersand operator, but used it twice to concatenate with a space in the middle. Concatenate works for two cells, but you c. Below are a few examples of how to combine two QUERY results vertically. This example will use the TEXTJOIN and IF Functions to create a text string of Player Names which relate to a Team value of Red =ARRAYFORMULA(TEXTJOIN("",FALSE,IF(C3:C8="Red",B3:B8,""))) The TEXTJOIN Google Sheets function combines text in multiple strings into a single cell. If you encounter any issues when using CONCATENATE in Google Sheets, here are a few troubleshooting steps to follow: - Check for typo or syntax errors: Carefully review the CONCATENATE formula for any typographical errors or syntax mistakes. Refer to the second cell with the value and enter an ampersand again. 2. Google Docs Editors. 1. Tap on the formatting icon at the top menu. The function looks like this: =SPLIT (A2, “, “) The delimiter consists of two characters here, a comma and space. I was working with a formula someone helped me with to do one single range: =ARRAYFORMULA ( {"Job Responsibilities";IF (A2:A="",,TRIM (TRANSPOSE (QUERY. This is what I used to combine the data and the result that I get:Step 3: Use a Google Sheets function to port your data over. In the end, hit. First, let’s enter the following dataset into Google Sheets that shows the total number of sales made by various employees at a company: Step 2: Add Commas to Numbers. This is sometimes useful for seeing your whole formula for debugging, keeping a copy of your formula so you can copy and paste bits of it elsewhere for testing. CHOOSE is a bit strange; for whatever reason, in the newest version. It will be selected. Click on the cell you wish to add your combined cells to. Click on the cell where you want to combine customer. It is particularly useful when you need to merge multiple data points into a single entity, such as creating full names, addresses, or custom formulas. You have now merged the data from two cells into one cell, and they are separated by a comma. There, click on CONCATENATE to insert the function into your spreadsheet. The following examples show how to use each method in practice with the following two cells in Google Sheets: Example 1: Use CONCATENATE() to Concatenate with Line Break in Google. Enter your CONCATENATE formula, making sure to reference the cells you want to combine, and also the commas. =TEXTJOIN (", ",TRUE,A2,B2,C2) The Address column in the table above was created using the TEXTJOIN function. ARABIC; 3 of 43. For this. Search. The issue I'm running into is that I need it to return an empty cell. You should also note that this method adds a comma and has no spaces between the two combined names, which may not be ideal sometimes. ArrayFormula with TEXTJOIN - Combine data of two columns on the same row/cell. First, click into the new spreadsheet where you’d like to add data into. Type the address for the first column that you want to combine with, such as A1:A. Result. =CONCATENATE(A1,CHAR(10), B1) Drawbacks of CONCATENATE: CONCATENATE seems to be the most convenient option among the three functions. Note. You should also note that this method adds a comma and has no spaces between the two combined names, which may not be ideal sometimes. Search. Here’s how you use it in your spreadsheet: Toggle a cell and type =IF (. =CONCATENATE (A1&" "&B1)Post to the help community Get answers from community members. But textjoin cannot be used in Arrayformula as far as I know and I would like ot find a suitable replacement that can also be combined as a. In the cell in which you want to display the combined data, type. 1. To handle this scenario, use a substring for the delimiter. Step 4: Next, select Delimited in Convert. In the example below, you want to VLOOKUP on First & Last Name. Step 2: A smaller window shows up in the middle of the screen. Just select all Google Sheets cells where you want to remove whitespace and choose Data > Trim whitespace in the spreadsheet menu:Commas can also be added to lists in Excel and Google Sheets with the use of the TEXTJOIN Function. I created this formula but it's not an array based. Step #2: Enter the formula. I have 2 google sheets with data as shown in the screenshot above. Type equal sign (=). The steps are: Step 1: First, select the cell which we want to split. Choose Delimited as the file type that best describes your data. We can use Query function to combine columns in the Vlookup result. But if you replace the quotes with CHAR (34) — the character code for straight double quotes — the. This can be particularly useful when working with text data, such as names, addresses, or product descriptions. I can combine the same in “Sheet3” using a Query formula as below. The solution is to use the & operator instead (as you have done in your final formula). 2. For example, suppose you have the following transactional data on sales. =TEXTJOIN(",",TRUE, B3:D3) You enter the delimiter into the formula that you want to use to separate the. When you add a phone number with a prefix “+” sign like +1234545 via typing in a column, AppSheet will automatically add a single quote prefix in the google sheet cell. =QUERY (A3:B9, "select A, Sum (B) where A is not null group by A") The data ‘A3:B9’ is the. TEXTJOIN (“ “, TRUE, “hello”, “world”) TEXTJOIN (“, ”. This formula will prefix and suffix double quotations marks with the text Hello. On top of concatenating, is it possible for me to replace those empty cell with 0 in one line of command? E. Blog/ Ultimate Guide to CONCATENATE in Google Sheets Last Modified: March 6, 2023 - 8 min read Hannah Recker Leverage this ultimate guide to. Concatenating With a Comma Concatenating with a comma comes in handy when you need to create lists, bibliographies, or any content that requires a separation of elements using commas. After that, enter an ampersand and specify a delimiter with double quotation marks. You can use the following basic formula to concatenate a range of cells with a comma in Google Sheets: =TEXTJOIN(", ", TRUE, A2:C2) This particular example concatenates each cell in the range. In a blank Google Sheets, in cell A1 enter the text Hello. Search. Cell B3 in the table is empty, but the TEXTJOIN function did not include an additional delimiter to represent this empty cell. The CONCATENATE function in Google Sheets is used to merge multiple data strings into one. Step 2. It's from an earlier iteration, so it's not 100% exact with what I said above, but the goal is still the same. Select the cells that you want to merge. One way to use TEXTJOIN is when you have columns containing the first. It can be a text string, a number, or a cell reference containing the delimiter. Within the parentheses, specify the cells or text strings you want to combine. ; Wrap text in the. google-sheets. It's easy to just create an array with CONCATENATE:Step 1: Understand the Data. How to Combine Text Strings Using TEXTJOIN in Google Sheets. One such feature is the ability to concatenate numbers and strings, allowing users to combine data effectively. This method can be used when you have data in two columns that are supposed to be combined with a space, comma (,), or a hyphen (-) in between. Out of these cells: The last cell's output contains the full string, concatenating the multiple cells with comma; and. Suppose we have the following dataset in Google Sheets: We can use the following formula to query for rows where the first name contains “Andy” and concatenate the first, middle, and last names into one cell per row: In OOCalc I want to use the CONCATENATE function to add quotes to each string in column A. For this example, we will select C2 as the text_to_search. Provide a value when the answer is false like “Mismatch” and close the function. But instead of just combining values in one cell with the next, you want to add a separator such as a dash, a comma or a space character in between. Next, select the same individual's last name (e. We used the CONCATENATE function to produce the Full Name text seen in Column D. Type the equal sign ( = ), then type CONCATENATE . g. . Using this formula, you can add ID- to the beginning and -1 to the end of the value in cell D2. Suppose we have the following dataset in Google Sheets that contains the city location and team name of various basketball teams: If we use the following CONCATENATE function to concatenate the city and team names into one cell, no space will be added by default: = CONCATENATE (A2, B2) For example, keywords of a specific topic that you would like to put each in a separate cell. It is available in Excel… Step 1: Click on the cell where you want the merged information to be. value2 – the value to join. Then, remove the comma and concatenate the names using a space character to separate them. To apply the formula in this cell to more cells, with the cell selected, Click the blue handle, and Drag handle, and Drop it on the last. To use the Concatenate function, firstselect the cell where the combined data will be placed. In a separate column of your spreadsheet, enter =CONCATENATE (. Can I get. Step 1: Select a new column where you want the combined data to appear. instead of. 0. So in cell B1 I want to do: =CONCATENATE("\"",A1,"\"") OOCalc does not like this, or without the escaping backslash. Sum by month; SUMIF cells if contains part of a text stringTo use SUM: Open your Google Sheet. Type a formula to merge the first cells in each column (most likely, these will be cells from row 2 unless your dataset doesn’t have a header row). We do this in two ways. Below are the steps to split the cell into multiple columns using Split Text to Columns feature: Select the cells that have the address that you want to split. So in order to use line breaks with a concatenate function, you can use the following formula. Click on any cell to make it the active cell. 1 of 43. By adding a delimiter, the ampersand operator becomes a good solution. If you have any empty rows in Sheet1, you end up with a bunch of empty rows between each. if you could live with the end-comma present in the output you can try: =ARRAYFORMULA ( {QUERY (QUERY ( {A2:B, B2:B}, "select Col1,max (Col3) where Col1 is not null and Col3 <> ',' group by Col1 pivot Col2"),. To begin with, open your data spreadsheet and select a blank cell in which you want to display the linked data. With this tip, you’ll be able to make your spreadsheet look top notch by adding dropdown lists to cells and color-coding tasks. Search. In this scenario, the CONCATENATE function takes three arguments: two cells and a delimiter (space, in our case). Step-3 Type Your Formula And Text: Then, it is time to proceed to the main task. =C3&D3. Summary. I have this formula and this works for my needs however it also returns a bunch of commas when there are numerous blank cells. The TEXTJOIN function in Google Sheets can be a helpful tool when you need to combine data from multiple cells into a single string. We need to combine the values from these cells into one. This feature overwrites those cells without any warning. Also, this resource-hungry formula may return errors in a larger data range. In our case, the cell contents are separated with spaces and commas, so we select Delimited, and click Next . Google Sheets automatically enters commas to separate strings of data. Using the CONCATENATE Function. Its syntax involves listing the desired text strings or cell references inside the function, separated by commas.