Software & Apps Google Drive Google Sheets: Concatenate Function Combine multiple cells of data in a new cell by Ted French Writer Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. our editorial process Ted French Updated on April 15, 2020 reviewed by Ryan Perian Lifewire Tech Review Board Member Ryan Perian is a certified IT specialist who holds numerous IT certifications and has 12+ years' experience working in the IT industry support and management positions. our review board Article reviewed on Apr 08, 2020 Ryan Perian Google Drive Sheets Docs Slides Tweet Share Email In Google Sheets, concatenation combines the contents of two or more cells in a worksheet into a third separate cell using the CONCATENATE function or its newer version, CONCAT. Here's what the CONCATENATE function does and how to use it. These instructions use the Google Sheets app for iOS. The desktop version may have differences. CONCAT and CONCATENATE do similar functions. The older version supports ranges and more cells. In a CONCAT function, you can only combine two cells, but the formatting is the same. How to Write a Function in Google Sheets A function in Google Sheets (or other spreadsheet programs like Microsoft Excel) has three parts, in this order: An equals sign (=). This tells the program that you're entering a function.The name of the function. This is usually in all-caps, but that isn't necessary. Some examples are SUM, ROUNDUP, and PRODUCT.A set of parentheses. If the function includes work on a set of numbers in the spreadsheet, these numbers go in the parentheses to tell the program which data to use in the formula. Some functions, like NOW, which returns the current date and time, has the parentheses, but these are empty. Lifewire / Tim Liedtke How to Write a CONCATENATE Function CONCATENATE follows the format above, but it has some specific features. The general layout is: =CONCATENATE(string 1, [string2, ... ]) The strings refer to specific data in the spreadsheet. These strings can be individual cells or ranges of cells, like entire rows or columns. The rules for a valid function are that you present at least one data point (or argument), and each point or range is separated with a comma. A valid CONCATENATE function may look like this: =CONCATENATE(A1,B2:B5,A2) When Sheets runs the function, the result displays every entry in the cells the formula mentions arranged in order. If a function has a range that includes several rows and columns, it lists the contents in order from left to right and top to bottom, as you would read the rows and columns. How to Add Spaces to a CONCATENATE Function Concatenation doesn't leave a blank space between words. However, you can build spaces into the formula. Wherever you want a space, insert a set of double quotation marks with a space between the quotation marks. The sample function above, with a space between the first two strings, would look like this: =CONCATENATE(A1," ",B2:B5,A2) Limits to Concatenating Numbers Google Sheets formats the result of a CONCATENATE function as text. If your entries are text, this doesn't affect anything. But, if you use numbers, you can't include the result in math functions such as SUM and AVERAGE. That's because math functions ignore the text. How to Wrap Text in Google Sheets How to Enter the CONCATENATE Function Google Sheets doesn't use dialog boxes to enter the function arguments as Excel does. Instead, it has an auto-suggest box that appears as you type the name of the function into a cell. Enter the information you want to concatenate, then select the cell where you want the combined data to appear. Type the equal sign ( = ), then type CONCATENATE. Suggestions appear above the keyboard as you type, so you don't have to enter the entire word. Tap the cells in the order you want to combine the cells. Or, drag and select a range. Google Sheets automatically enters commas to separate strings of data. In the final result, strings appear in the order in which you selected the cells. To add a space, put the cursor between the two entries you want to separate, then type two double quotation marks with a space between each. This element lets you add any text you want to the function. The quotation marks on the default iOS keyboard don't work for this function. Use the desktop version or add the space to the terms you're concatenating, if possible. Tap Return or the checkmark to run the function. The concatenated data appears in the cell. Repeat the process for all the cells you want to concatenate. If you use absolute values with dollar signs in the formula, you can use autofill for specific rows and columns. If you change the text in one of the cells in your formula, the concatenation result updates. You can also access CONCATENATE through the Function button next to the text box on iOS or in the upper-right corner of the screen on the desktop. The mobile version looks like the letters fx, and the desktop version looks like the Greek letter sigma (∑). CONCATENATE is under the Text heading in the Function menu.