Add a comment. I need to populate the Column C with all the possible combinations of the values in Columns A and B. Join a list of values into a single cell. In. Also if your comma separator is the comma character (Spain for instance), the union character for. SPLIT: Divides text around a specified character or string, and puts each fragment into a separate cell in the row. Table of Contents hide. Example: Concatenate Strings with Space in Google Sheets. In this comprehensive guide, we will explore the CONCAT formula in Google Sheets. To create full names in column C, use the CONCAT function in Excel. Você está usando os produtos do Google, como o Documentos Google, no trabalho ou na escola? Consulte dicas, tutoriais e modelos úteis. . Use quotation marks to separate the cells you are combining. About;. Select the sheets you want to. To chart multiple series in Google Sheets, follow these steps: Insert a chart on the tab that you want your chart to appear on (Click "Insert" on the top toolbar, and then click "Chart") Select the chart type (Column, Line, Combo, etc. 1. Combine multiple email addresses (in separate cells) into one cell (separated by comma) Google Sheets or Excel. This formula concatenates the value in cell A2, then concatenates the value in cell B2, and finally adds the domain @myexcelonline. To create a new column, right-click on a row, column, or cell and select + Insert 1 column (left or right) from the drop-down menu. In this article, I’ll demonstrate 2 simple ways to use the QUERY function to concatenate two columns in Google Sheets. 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. - Didn't change the name of the main sheet if the add-on was started from a Chart sheet. To join two or more values by typing them, use the formula as follows. Você está usando os produtos do Google, como o Documentos Google, no trabalho ou na escola? Consulte dicas, tutoriais e modelos úteis. In this tutorial, we will learn all the methods to write a formula for this. Good afternoon. But you can add any text or punctuation marks. Follow this simpleguide to learn how. Start by opening your Excel spreadsheet and selecting an empty cell. 1. It's common to desire to divide a cell's content into separate cells or, conversely,. 1. To link to a certain web page, you can simply type its URL in a cell, hit Enter, and Microsoft Excel will automatically convert the entry into a clickable hyperlink. We need to combine the values from these cells into one. 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). Click on the first cell you want to merge, type a comma, and then click on the next cell. Every cell with textjoin =TEXTJOIN("",TRUE,BE117:CT117) that is literally it, wants to send an email when quick. If we wish to combine two columns in Google Sheets, we can use the QUERY function to do so. CONCATENATE text strings and numbers inches Google Sheets; Google Sheets: join ketten with separators; Concatenate with line. In this method, we are using the TEXTJOIN function to concatenate multiple cells. Note: This feature is available on Windows or Mac if you have. Start the add-on. Next I put those two FILTERs into CONCATENATE and add the brackets and comma needed. Splitting JSON-Formatted Single Column Into Rows and Columns in Google Sheets. 3. Type the CONCAT function and select the cell with the first string. Merge values in each selected column and place them to the top cell. What is "concatenate" in Excel? In essence, there are two ways to combine data in Excel spreadsheets: Merging cells; Concatenating cells' values; When you merge cells, you "physically" join two or more cells into a single cell. 1. , A7,B7). . Related. With the CONCATENATE function, separators are displayed if the cell is empty. We can add text both after and before the given formula. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more. I have created a document where we have Google Ads and Bing Ads tabs that we want to combine in the GDS Total Ads tab. To merge them into a single cell, we would employ the CONCATENATE function as follows: =CONCATENATE (A1, " ", A2). Google Sheaves CONCAT function; CONCAT optional: concatenation operator punctuation (&) How to use CONJUNCTION the Google Sheets. Click on the autocomplete option to get the formula as “=SPLIT (”. Step 1: Select the sheets to combine. Concatenate Strings (Two or More) in Google Sheets; Concatenate Strings with a Separator in Google Sheets; Separate Names (First and Last Name) in Google Sheets; Combine Two. Click the target cell. The data is currently all in Column A, with commas separating multiple values in each row. By including a separator within the function, you can add a specific. To unfreeze, select a row or column. Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text. Besides, we need the use of IF and ISBLANK functions to complete the formula. Press = (the equal sign). While you can still use CONCAT in Google Sheets, you could consider the CONCATENATE Google Sheets function an upgraded version of it. Every cell with textjoin =TEXTJOIN("",TRUE,BE117:CT117) that is literally it, wants to send an email when quick. Enter the CONCATENATE function, including the cells you want to. To begin, launch your Google Sheets application and open the spreadsheet in which you want to incorporate the CONCATENATE function. You can also take values from your cells and join them. ARABE (ARABIC) Fonction ASC. If you want to combine all the cells in column B, use this formula: =TEXTJOIN(” “, TRUE, B:B) 2. Step 3. . If you want to combine all the cells in column B, use this formula: =TEXTJOIN(” “, TRUE, B:B) 2. You can use the following steps: First, type TEXTJOIN in cell B1. Besides, we need the use of IF and ISBLANK functions to complete the formula. Using TEXTJOIN to Combine Values with Separator You can use the below steps to write this formula: First, enter TEXTJOIN in a cell. The CONCATENATE function allows you to combine text from different cells into one cell. For example: =C2&”_”&D2. Limitations of standard functions used in the formula. Using the CONCATENATE Function From this point onward we will be looking at some specialized built-in functions for. When the file appears on your Sheetgo. Enter the following formula in cell C2: =CONCATENATE (A2, ” “, B2) The full name will be produced in cell C2 by combining the initial name from cell A2, a space (” “), and the last name from cell B2. There, click on CONCATENATE to insert the function into your spreadsheet. Expand the selection area using the selection handles to highlight the. See also. CONCATENATE Excel function joins two or more text strings into one string. Use Ampersand(&) Symbol to Concatenate with Space. Concatenating from a table by filtering first. Compatibility: Excel 2010 or later for Windows. A1&CHAR (10)&A2) Adding a line break (or new line, or carriage return) in Google Sheets isn't obvious as just pressing Enter exits the cell. But to make the result look pretty and readable, you should add some extra characters. Step 3: Select the first file to merge. =CONCAT (A2, " Family"). Google Sheets CONCAT function; CONCAT alternative: concatenation operator ampersand (&) How to use CONCATENATE in Google Sheets. Share. If the data isn’t in the sheet yet, paste it. Notice that the comma is in double quotes, followed by a single-space character. Now, enter the delimiter to use a. I want to merge TWO columns of data (join or concatenate). CHIFFRE. These are the CONCATENATE function and the newer and simpler CONCAT function. In Google Sheets, the CONCATENATE function is used to join two or more text strings into one string. Click Kutools > Merge & Split > Split Cells, see screenshot:. To combine columns horizontally in Google Sheets, follow these steps: Type =ARRAYFORMULA ( to begin your formula for combining columns. The example. Here is an example: we want to combine 2 columns with the First Names and Last Names into one. Learning how at combine total in Google Sheets can be easy as pieonce you know what to to. CONCATENATE text strings and numbers in Google Sheets; Google Sheets: join strings with separators; Concatenate with line break in. then the next matrix of cells (to which the first process also happens) //note char(13) is a carriage. Click the first cell that you want to refer to in the join and then press + (the plus sign). I'd like to combine a range of cells of data so that it comes out with just one text string and a comma + space between each one. Here I am selecting Textjoin, as it can omit blank cells. Komentar: 0. Instead, I’m. ) Here, text1, text2, text3, and so on represent the cell references or text strings you want to combine. Suggestions appear above the keyboard as you type, so you don't have to enter the entire word. Suppose you have a dataset, as shown below, and you want to combine columns A and B and get the result in column C. In essence, there are two ways to combine data in Excel spreadsheets: Merging cells; Concatenating cells' values; When you merge cells, you "physically" join two or more cells into a single cell. Jbl Alarm Clock Instructions. Using Notepad to Merge Columns Data in Excel. So, in our case, the CONCATENATE Google Sheets formula will look like this: =CONCATENATE(A2," ",B2) Google Sheets CONCATENATE multiple cells (more than 2) Let’s move further and concatenate a few more cells into. To create a new column, right-click on a row, column, or cell and select + Insert 1 column (left or right) from the drop-down menu. Click on the file and then press the. 00:00 Introduction00:12 Concatenate usin. I have an unsolved situation like the one described in the following diagram. Note. =CONCATENATE(string1,”delimiter”,string2,”delimiter”,string3…) Here’s what each parameter means: string1,string2,string3… are the cell reference. While CONCATENATE is a powerful function, there are a few common mistakes that users should avoid when using it in Google Sheets: Forgetting to enclose text strings in quotation marks: When using CONCATENATE with text strings, it is crucial to enclose the strings. Enter the formula given below in the blank cell. Use CONCAT Instead of CONCATENATE. Close the formula with a parenthesis and press Enter. Step 4: Pick columns to add or update in the main sheet. You can go through a process of steps using functions. I have been successful in using concatenate: =ArrayFormula (concatenate (C3:F&", ")) but there are extra commas that don't need to be there in between some data and a lot of extra commas at the end. Google Sheets / Excel - Create a minimum list based on multiple cells. Select OK to complete the function. 1. Manage governance policies Manage branded apps. Although it looks messy but I'll explain. Skip to navigationDiscuss the spreadsheet application. Post Reply. Get help from the Google Sheets experts. Join data vertically dividing with line breaks. " To concatenate these two columns and create a full name, you can use the following formula: =CONCATENATE. Use the FIXED function. JOIN : Concatenates the elements of one or more one. g. 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. To do this, add a comma as a separator in your formula. Here's an example: =CONCATENATE(A2, " ", B2) In this formula, A2 and B2 are the cell references for the first and last name columns, respectively. Example below:Closed this search box. Step 4: Enter the syntax of the formula that you want to use. Google Sheets - How to concatenate cells that meet a condition. This app allows you to merge two or more Google Documents, Spreadsheets into a single document. Press Alt + Enter or Ctrl + Enter. Okay, spreadsheets offer some tools for. In the first argument, enter a space using double quotation marks (“”). 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. Join a list of values into a single cell. If your groups names have spaces, use the & operator to concatenate a separator. Note that one cell looks blank because the text string in cell A1 has two adjacent. Click in the cell in which you want the result. Here is an overview of what we will archive:Step 1. Learn how to combine cells in Google Sheets: concatenate strings on formulas and a special add-on. Note that one cell looks blank because the text string in cell A1 has two adjacent. =CONCATENATE (A4," ",B4)2. It then returns the accumulated value. “TRUE” is used in the second argument to. Get insights together with secure sharing in real-time and from any device. ]) delimiter: This is the character or string that will be used to separate the text values being joined. ) Step 2: Click the Merge Cells drop-down arrow in the toolbar or Format. Step 2: Select the cell in the “Fruit” header and enter the Query formula shown below. Type the equal sign ( = ), then type CONCATENATE . Find answers from experts and other users in the Google Docs Help Community. When a range with both width and height greater than 1 is specified, cell values are appended across rows rather than down columns. In case the delimiter appears in the cell multiple times, the function can return text before a specific occurrence. 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). The INDIRECT function can be combined with the MATCH function to return a dynamic range of cells. The CONCATENATE function can be used to merge two cells or multiple, and you can add line breaks wherever you want as well. Please do as follow: 1. . CAR (CHAR) EPURAGE. 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. There are two ways to concatenate cells with a line break in Google Sheets: Method 1: Use CONCATENATE() = CONCATENATE (A1, CHAR (10), A2) Method 2: Use TEXTJOIN() = TEXTJOIN (CHAR (10),. It should look something like this: =CONCATENATE (A2,“ ”,B2) How to use the CONCATENATE function in Google Sheets - CONCATENATE cells with spaces. Here's one of the drawbacks: it can't look at its left. Applying CONCAT Function. Ablebits blog; Google Sheets Hot. Click on Upload in that screen to choose the local CSV file. Choose Delimited as the file type that best describes your data. Open your Google Sheets spreadsheet. To concatenate the values in this column with a comma delimiter, you can use a formula like this:In this video I demonstrate four different methods for concatenating or joining text or numeric values using formula. And in this tutorial, we will learn to write and understand all these formulas in detail. How To Merge Google Sheets (Manually & Automatically) - Existing spreadsheet. CONCATENATE text strings and numbers in Google Sheets; Google Bed: combine ketten with separators; Concatenate equal line break in Google Leaf; Combine date and point in Google Sheets; Combine posts in Google Sheets; Concatenate furthermore add text by move; Split cages in Google Sheets; Wie go merge cages in. Example: Use CONCAT with QUERY in Google Sheets. Type =CONCAT (CellA,CellB) , but replace CellA and CellB with your specific cell references. For example, keywords of a specific topic that you would like to put each in a separate cell. =CONCATENATE (TRANSPOSE (A1:A5)&” “) Now, select the entire inside portion of the concatenate function and press F9. In the first example, we go through. When delimiter is omitted, the result of JOIN is similar to that of CONCATENATE. I need these combined together (ie [Arizona,54000], [Virginia,60000], etc. CONCATENATE text play and numbers in Google Sheets; Google Sheets: concatenate strings with separators; Concatenate using line. 2. 1. Click the Data tab. The space enclosed in quotation marks separates the first and last names. Here we are using the AVERAGE function. Formulas List. In case you need years as well, you'll have to create the formula in the neighboring column since JOIN works with one column at a time: =JOIN (", ",FILTER (C:C,A:A=E2)) So, this option equips Google Sheets with a few functions to combine multiple rows into one based on duplicates. Skip to navigation On your computer, open a spreadsheet in Google Sheets. To pin data in the same place and see it when you scroll, you can freeze rows or columns. To add a line break in a: Cell: use Ctrl + Enter (for Windows) or Ctrl + Return (for Mac) Formula: concatenate with the CHAR function (e. As a result, you have one larger cell that is displayed across multiple rows and/or columns. =CONCATENATE(A1,CHAR(10), B1) Drawbacks of CONCATENATE: CONCATENATE seems to be the most convenient option among the three functions. To use a different separator, simply change the “_” at the end of the formula with something else. Utilize the CONCATENATE formula with cell references and commas: =CONCATENATE (B2, ", ", A2). Example Sheets. Below is the formula that will do this: =A2&B2. Share. TRANSPOSE() //takes matrix as argument and returns transposed matrix SPLIT() //breaks apart a string based on a delimiter character (char(13) here) ARRAYFORMULA() //applies the formula within to array vs cell CONCATENATE() //joins each cell in each range with a char(13), then the next cell. –. 11 Ideal Examples to Concatenate Multiple Cells in Google Sheets. How to combine text in one cell with a number in another cell. Editor Google Dokumen. Use TEXTJOIN Function to Concatenate Multiple Cells Ignoring Blanks. For example, you may want to combine a column of first names with a column of last names to form a singular column with first and last names. This is commonly referred to. . And in this tutorial, we will learn to write and. SUMIFS in Google Sheets - 3 things to remember. Using Ampersand Operator with ARRAYFORMULA Function. Then, click on Insert in the top bar, click on Function, and then on All. Select the cells value that you want to combine. Type =CONCAT (. Bound to content. I have a Google SpreadSheets doc with three columns A, B and C. This formula concatenates the value in cell A2, then concatenates the value in cell B2, and finally adds the domain @myexcelonline. Merge column results of FILTER in google sheets. Step 1: Select an empty cell. In Google Sheets, just like a comma, you can use any separator to concatenate two or more values. Next, we are going to concatenate the same dataset with the same if condition in Excel. 0. The main benefit of this function is to combine numerous. Follow edited Jun 7, 2021 at 3:45. In Google Sheets, CONCATENATE is a function that combines the data from two or more individual cells into one new cell. Type the address of the other column that you want to combine with, such as B1:B. Once the formula bar is active, you can begin to type in your formula. com. To begin with, open your data spreadsheet and select a blank cell in which you want to display the linked data. You can also use the arrow buttons on your keyboard to navigate to the desired location. Syntax. But the same method applies by using b,c5 instead of b&c5 but now there will be a separate entry for each ref and for each separator. ** ★ New features ★ - Merge sheets from different spreadsheets. Hi, using simple textjoin for the first time in a spreadsheet that was converted from a google sheet. Step 2: Select the cell where you want to apply the formula. In the value_1 field, type in “ID-“. The delimiter is the comma and the space you want between the data you're merging. 4. ”. Skip to main content. Basically it's an array of cells from column A to E, some of them filled, others empty, and I would like to find a formula to get the results in red which work as follows: For each non empty cell, the result takes the corresponding cell in the header, and combines them with. Here's an example: =CONCATENATE(A2, " ", B2) In this formula, A2 and B2 are the cell references for the first and last name columns, respectively. g. Search this site. Then, select an individual's first name (e. Instead of sharing a Google Sheet spreadsheet with edit permissions for anyone, share it with view only in order to assure that readers will see the original spreadsheet. Double-click on the cell or press F2 so that you are in edit mode in the cell. Step 1: Open the CONCAT function in an empty cell. 3. In the value_1 field, type in “ID-“. Format as textReturns the formatted text from the first argument. 0. Video: How to merge values in Google Sheets; How to use Merge Values. Under Source data > Multiple files, select the first file you want to import data from. See Also. Find answers from experts and other users in the Google Docs Help Community. Get insights together with secure sharing in real-time and from any device. Concatenate the Lookup Columns. Here, replace Mahesh and Makvana with the terms you want to join. “TRUE” is used in the second argument to. For example, = {SUM (A1:A10), SUM (B1:B10)} will produce two values. Delimiter: the special character in the data to use as markers for splitting it to columns; they are closed in double quotes. CONCATENATE and CONCAT to Join Multiple Cells. This is useful for organizing and formatting your data in a more efficient way. Print view; Search Advanced search. Well,. I have an unsolved situation like the one described in the following diagram. To concatenate strings with space in Google Sheets, you need to use a space delimiter: " ". In the following section, we will use the Ampersand (&) symbol. Your spreadsheet will offer you a chart type for your data at once. Confirm that the cells merge correctly. In Google Sheets, just like a comma, you can use any separator to concatenate two or more values. Step 2: Grab two things from the original sheet. . This method returns a list of substrings. Thus, if you need to merge 2 Google sheets and pull IDs (1st-column data) based on berries (2nd column), VLOOKUP won't help. Link to table and screenshot atta. Select the cell you want to combine first. Use TEXTJOIN Function to Concatenate Multiple Cells Ignoring Blanks. { {Data!A:A, Data!B:B}; {Data!A:A, Data!C:C}} . In the first argument, enter a space using double quotation marks (“”). Start with the UNIQUE function. To use this method, first, launch your spreadsheet with Excel. If the desired cell has been referenced in the formula, then enter ," ",. And it happens automatically. It can be a text string, a number, or a cell reference containing the delimiter. Concatenate cells but exclude empties in Excel/google Sheets. The simplest way of moving rows or columns in Google Sheets is by selecting the entire row or column you want to move, and then dragging and dropping it at the desired spot. First, identify the cells that contain the text strings you wish to combine. =CONCATENATE ("Pay an amount of ",A1) The result of this formula would be like “Pay an amount of 2500. The item can be a text value, number, or cell reference. Applying CONCAT Function. First, we concatenate the lookup columns to create an array of unique IDs, which enables us to look up all the criteria simultaneously. Excel adds double quotation marks around the space. In our example, I will be selecting C2. This tutorial will show you how to make columns D and E combine into one column, with a comma separating the data from each cell. So in order to use line breaks with a concatenate function, you can use the following formula. In the popped out dialog box, please specify the operations you need as following screenshot shown:To start using the CONCATENATE function in Google Sheets, you’ll need to create a new spreadsheet or open an existing one. SPLIT: Divides text around a specified character or string, and puts each fragment into a separate cell in the row. A Sample of Practice Spreadsheet. Some future version of Excel will no longer have the CONCATENATE. To create a new column, right-click on a row, column, or cell and select + Insert 1 column (left or right) from the drop-down menu. Google Sheets - How to concatenate cells that meet a condition. Step 1: Select the cell where you want to add the CONCATENATE function, then type =CONCATENATE followed by the opening parenthesis, as shown below: Autocomplete option appears while typing in Google Sheets. Close the formula with a parenthesis and press Enter. The function looks like this: =SPLIT (A2, “, “) The delimiter consists of two characters here, a comma and space. g. 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. Instead of writing a cell as an argument, our first argument is the ROW function. These are the cells you want to combine. In case you need years as well, you'll have to create the formula in the neighboring column since JOIN works with one column at a time: =JOIN (", ",FILTER (C:C,A:A=E2)) So, this option equips Google Sheets with a few functions to combine multiple rows into one based on duplicates. Click Kutools > Merge & Split > Split Cells, see screenshot:. Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web More. Viewed 2k times 2 How can I concatenate lines from two (or more) multiline cells like this? so that column C generated by something like: =concatenate(A1{one line}, " is a ", B1{one line}). The item can be a text value, number, or cell reference. Now, it creates the rows/cols that are the inverse (rows to cols, or cols to rows) of the specified range. Let’s see it in action in our dataset: =B3&C3. Wrapping Text in Google Sheets: Keeping Text In Cell - 0707354. The syntax for the TEXTJOIN formula in Google Sheets is as follows: =TEXTJOIN (delimiter, ignore_empty, text1, [text2,. In the Advanced Combine Rows dialog box, click the column name that you want to combine based on, then click Primary Key button, see screenshot: 4. This function probably doesn't do what it might have done. The Concatenate Operator (&) will connect the two columns, Columns C and D. Google Sheets: How to Filter Vertically Merged Cells. Usually, if you analyze indicators. We use =CHAR(10) for line break in google sheets. Instead of writing a cell as an argument, our first argument is the ROW function. Type in the initial part of the formula, which is =CONCATENATE. Then, select an empty cell where you want the concatenated result to appear. You can use the following steps: First, type TEXTJOIN in cell B1. Specify the delimiter you want to use, such as a comma or space, inside quotation marks. Let’s see a simple example using SPLIT to separate a list of names in cell A1: This simple SPLIT formula will separate these names, using the comma as the separator: =SPLIT (A1,",") The result is 5 cells, each containing a name. com. 3. CONCAT (value1, value2) The CONCAT function takes two values and combines them together in a single cell. An array of values may be populated by a single function using an embedded array. Growing list of Excel Formula examples (and detailed descriptions) for common Excel tasks. Combine rows of varying length google sheets. Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Sheet1!A:A {12, 131, 45} Sheet2!A:A {12, 131, 46}. SPLIT: Divides text around a specified character or string and puts each fragment into a separate cell in the. Sometimes you may need to combine text from two different cells in a spreadsheet. 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. In new versions if Excel, you can also use the CONCAT function to concatenate values from separate cells and ranges,. Now, spreadsheets present several tools by this task. Next, type the equal sign = to begin the function, followed by ARRAYFORMULA and an opening bracket (. Excel adds double quotation marks around the space. But this time, we are going to use the CONCAT function to concatenate the strings. In the first cell of a blank column, type the following: “ =ARRAYFORMULA (A2:A & ” ” & B2:B) ”. After installing Kutools for Excel, please do as follows:. The CONCAT function is a powerful tool that allows you to combine the contents of two or more cells into a single cell. 2. Find the add-on in Power Tools. Combining cells in Google Leaves is halves the work. intervals, or other chars, or even separate those records includes other text. Type ",. 📌 Step 2: Open a notepad file. In this method, we are using the TEXTJOIN function to concatenate multiple cells. You can type it either in the cell itself or the formula bar above. Modified 5 years, 3 months ago. All together, our formula is written: =TEXTJOIN (” “,TRUE,A2:C2) 3. Let’s see it in action in our dataset: =B3&C3. Select the cell where you want to put the combined data. After that, in the third argument, refer to the range from where you want to combine the strings. Here are our five best tips to help you concatenate more efficiently with space in Excel: 1. . Using CONCATENATE Function. The Google Sheets CONCATENATE function allows you to combine values from two cells and separate them with a comma. However, the CONCATENATE function will stay available for compatibility with earlier versions of Excel. The formula (also the named function) combines data in multiple Sheet tabs in Google Sheets and has the following features.