[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
The CONCATENATE function in Google Sheets is used to merge multiple data strings into one. This allows you to combine text within multiple cells together. One of the most common examples, when the CONCATENATE function is used, is when you need to merge the two columns containing first names and last names into a single column. Combining texts within different cells can help to organize your spreadsheets more clearly, not only reducing the number of columns within your sheets but also allowing you to identify or manage your data more easily.<\/p>\n
In this article, you\u2019ll learn how to use CONCATENATE in Google Sheets, and provide a variety of examples both for how to use the function in different ways to achieve different results. You\u2019ll learn how to use CONCATENATE to combine two entire columns, how to CONCATENATE cells with spaces, commas, and separators, how to combine the CONCATENATE function with the IF formula, and finally, alternatives to the CONCATENATE function.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”how-to-use-concatenate-in-google-sheets” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
First, let\u2019s take a look at the syntax for the CONCATENATE function in Google Sheets:<\/p>\n
=CONCATENATE(data_string1, "delimiter", data_string2, \u2026)<\/p>\n
In the following example, I want to use the CONCATENATE function to combine the text within the \u2018First name\u2019 and \u2018Last name\u2019 columns together, in order to have a single column named \u2018Full name\u2019. These may also be referred to as CONCATENATE data strings. The following steps will show you how to CONCATENATE two columns in Google Sheets.<\/p>\n
1.<\/strong> Open your Google Sheet and click on an empty cell where you want your combined text to be. In this example, I will add a new column next to the cells I want to combine.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/concatenate-google-sheets-full-name-column.webp” alt=”CONCATENATE in Google Sheets \u2014 new Full name column inserted next to the first and last names” title_text=”New Full name column inserted next to the first and last names” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Enter the CONCATENATE function, making sure you include the cells you wish to combine. In this case, my formula will be =CONCATENATE(A2,B2), combining the data from ‘A2’ and ‘B2’ into a single cell.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/concatenate-google-sheets-formula.webp” alt=”CONCATENATE in Google Sheets \u2014 =CONCATENATE(A2,B2) typed in the Full name column” title_text=”=CONCATENATE(A2,B2) typed in the Full name column” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> There are 3 ways to apply the CONCATENATE function to the rest of your rows:<\/p>\n a.<\/strong> Google Sheets may trigger an autofill for the rest of your rows. You can click the tick to apply<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/concatenate-google-sheets-autofill.webp” alt=”CONCATENATE in Google Sheets \u2014 suggested autofill offering to fill the rest of the column” title_text=”Suggested autofill offering to fill the rest of the column” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n b.<\/strong> Select the cell containing your combined text. Click on the bottom right-hand corner of the cell and drag it down over the rest of your rows to apply the function.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/concatenate-google-sheets-drag-down.webp” alt=”CONCATENATE in Google Sheets \u2014 formula dragged down the Full name column” title_text=”Formula dragged down the Full name column” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n c.<\/strong> Fill the whole column with a single formula. CONCATENATE can’t do this on its own: given a range such as A:B, it joins every cell into one long string. Use ARRAYFORMULA<\/a> with the ampersand instead, for example =ARRAYFORMULA(A2:A20&B2:B20).<\/p>\n As you can see from the screenshot below, the text within the \u2018First name\u2019 and \u2018Last name\u2019 columns has been combined.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/concatenate-google-sheets-no-space-result.webp” alt=”CONCATENATE in Google Sheets \u2014 first and last names combined without a space” title_text=”First and last names combined without a space” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”how-to-concatenate-cells-with-spaces-in” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As you may have noticed from the screenshot above, the CONCATENATE function has not added spaces between the text from each cell. This may cause issues with legibility, especially when you share your Google Sheets file with someone else.<\/p>\n However, there is an easy way you can CONCATENATE cells with spaces. Simply add a space between quotation marks (” “) as the delimiter in your formula, in order to create spaces between your text in a combined cell.<\/p>\n 1.<\/strong> Click on the cell you wish to add your combined cells to. Enter your CONCATENATE formula, making sure to reference the cells you want to combine, and also the spaces. It should look something like this: =CONCATENATE(A2," ",B2)<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/concatenate-google-sheets-with-spaces.webp” alt=”CONCATENATE with spaces in Google Sheets \u2014 formula with a space between the first and last name” title_text=”Formula with a space between the first and last name” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Apply the CONCATENATE function to the rest of your rows, either using the autofill, drag-down, or data range method highlighted in the section above.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/concatenate-google-sheets-with-spaces-result.webp” alt=”CONCATENATE with spaces in Google Sheets \u2014 full names with a space between first and last names” title_text=”Full names with a space between first and last names” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As you can see, the combined cells now include a space between each text.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-concatenate-cells-with-commas-in” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Similar to adding spaces in the CONCATENATE function, to add a comma, simply add a comma and a space between quotation marks (“, “) as the delimiter to your formula. In this example, let\u2019s say I want to format my \u2018Full name\u2019 column so that the last name comes first, followed by a comma and the first name (i.e. \u2018Last name\u2019, \u2018First name\u2019).<\/p>\n 1.<\/strong> Click on the cell you wish to add your combined cells to. Enter your CONCATENATE formula, making sure to reference the cells you want to combine, and also the commas. It should look something like this: =CONCATENATE(B2,", ",A2)<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/concatenate-google-sheets-with-comma.webp” alt=”CONCATENATE with commas in Google Sheets \u2014 formula putting the last name first, followed by a comma” title_text=”Formula putting the last name first, followed by a comma” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Apply the CONCATENATE function to the rest of your rows, either using the autofill, drag-down, or data range method highlighted in the how to use CONCATENATE in Google Sheets section.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/concatenate-google-sheets-with-comma-result.webp” alt=”CONCATENATE with commas in Google Sheets \u2014 names listed as last name, first name” title_text=”Names listed as last name, first name” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As you can see, the combined cells now show the last name, a comma and the first name.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-concatenate-cells-with-separators” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Sometimes, combining cells together in Google Sheets can get confusing, as there may not be enough context that determines the relationship between the two. For example, let\u2019s say I wanted to combine the cells that refer to the order information – \u2018Product order\u2019, \u2018Quantity\u2019 and \u2018Total\u2019. Combining these on their own may be quite confusing without any additional context.<\/p>\n Using separators, i.e. text between each cell as a delimiter, I can add more information to make the relationship between each product clear. In this example, I want to add separators so that my combined cell contains the following: (\u2018Quantity\u2019) orders of (\u2018Product order\u2019), costing (\u2018Total\u2019).<\/p>\n 1.<\/strong> Click on the cell you wish to add your combined cells to. Enter your CONCATENATE formula, making sure to reference the cells you want to combine, and also adding your separators. In this example, my CONCATENATE formula would look like this: =CONCATENATE(E2," orders of ",D2,", costing ",F2).<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/concatenate-google-sheets-separators.webp” alt=”CONCATENATE with separators in Google Sheets \u2014 formula adding text between quantity, product, and total” title_text=”Formula adding text between quantity, product, and total” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Apply the CONCATENATE function to the rest of your rows, either using the autofill, drag-down, or data range method highlighted in How to use CONCATENATE in Google Sheets section.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/concatenate-google-sheets-separators-result.webp” alt=”CONCATENATE with separators in Google Sheets \u2014 order information written out as a sentence in each row” title_text=”Order information written out as a sentence in each row” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As you can see, adding text to create separators between my formula has provided the context I need to better understand my data.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-combine-multiple-columns-using-co” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The CONCATENATE function is also really easy to apply to multiple columns, as you can see in the section above. Simply continue adding your cell references to the formula, separated by a comma. Here is another quick example of how to do it.<\/p>\n Let\u2019s say I want to combine all of the customer data into one cell – \u2018First name\u2019, \u2018Last name\u2019, and \u2018Address\u2019.<\/p>\n 1.<\/strong> Click on the cell you wish to add your combined cells to. Enter your CONCATENATE formula, making sure to reference the cells you want to combine, and also adding your delimiters (as spaces, commas, or separators). In this example, my CONCATENATE formula would look like this: =CONCATENATE(A2, " ",B2,", from ",H2).<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/concatenate-google-sheets-multiple-columns.webp” alt=”CONCATENATE multiple columns in Google Sheets \u2014 formula combining first name, last name, and address” title_text=”Formula combining first name, last name, and address” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Apply the CONCATENATE function to the rest of your rows, either using the autofill, drag-down, or data range method highlighted in How to use CONCATENATE in Google Sheets section.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/concatenate-google-sheets-multiple-columns-result.webp” alt=”CONCATENATE multiple columns in Google Sheets \u2014 customer information combined in one column” title_text=”Customer information combined in one column” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”conditional-concatenate-using-if-formula” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You can also combine the CONCATENATE function with other formulas in order to apply more complex conditions to your data. For example, you can use CONCATENATE with the IF formula<\/a> to only combine certain cells that meet specific criteria.<\/p>\n For example, let\u2019s say I want to check whether I can approve the order status for each product. If the quantity of each product is over 8, then the order is automatically delayed. I can use the CONCATENATE and IF functions together so that any orders over 8 return an \u201cAutomatically delayed\u201d text. If an order is below 8, then the \u2018Product order\u2019 and \u2018Quantity\u2019 cells will be combined.<\/p>\n 1.<\/strong> Click on the cell you wish to add your combined cells to. Create a formula starting with your IF formula, followed by the CONCATENATE formula. In this example, the formula would look like this: =IF(E2>8,"Automatically delayed", CONCATENATE(D2,", ",E2))<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/concatenate-google-sheets-if-formula.webp” alt=”CONCATENATE with IF in Google Sheets \u2014 IF returning Automatically delayed or the combined order” title_text=”IF returning Automatically delayed or the combined order” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Apply the CONCATENATE function to the rest of your rows, either using the autofill or drag-down highlighted in the how to use CONCATENATE in Google Sheets section.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/concatenate-google-sheets-if-result.webp” alt=”CONCATENATE with IF in Google Sheets \u2014 orders over 8 marked Automatically delayed” title_text=”Orders over 8 marked Automatically delayed” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As you can see, every order with a quantity above 8 has returned an \u201cAutomatically delayed\u201d text. Every order below this value has successfully combined the \u2018Product order\u2019 and \u2018Quantity\u2019 cells.<\/p>\n [\/et_pb_text][et_pb_text module_id=”alternatives-to-the-concatenate-function” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n There are alternatives to the CONCATENATE function in Google Sheets, including CONCAT<\/a>, which joins exactly two values. These work in almost exactly the same way, so it\u2019s useful to try these to see which one you prefer.<\/p>\n You can replace your CONCATENATE function by adding an ampersand (&) between each cell reference. You can continue using delimiters to add spaces, commas or texts between your cell content.<\/p>\n 1.<\/strong> Click on the cell you wish to add your combined cells to. Make sure to add an ampersand between each cell reference and delimiter: =A2&" "&B2<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/concatenate-google-sheets-ampersand.webp” alt=”Ampersand alternative to CONCATENATE \u2014 first and last name joined with ampersands and a space” title_text=”First and last name joined with ampersands and a space” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Apply to the rest of your rows, either using the autofill or drag-down highlighted in the how to use CONCATENATE in Google Sheets section.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/concatenate-google-sheets-ampersand-result.webp” alt=”Ampersand alternative to CONCATENATE \u2014 full names filled down the column” title_text=”Full names filled down the column” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The JOIN function is a similar formula used to combine cells. The main difference is that the delimiter goes first, at the beginning of the formula, and JOIN places it between every value for you.<\/p>\n The syntax looks like this:<\/p>\n =JOIN(delimiter, value_or_array1, value_or_array2, \u2026)<\/p>\n 1.<\/strong> Click on the cell you wish to add your combined cells to. Make sure to reference the correct cells you want to combine and add the delimiter. In this example of joining the \u2018First name\u2019 and \u2018Last name\u2019 cells together, the formula will look like this: =JOIN(" ",A2,B2)<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/concatenate-google-sheets-join.webp” alt=”JOIN alternative to CONCATENATE \u2014 JOIN with a space delimiter and the name cells” title_text=”JOIN with a space delimiter and the name cells” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Apply to the rest of your rows, either using the autofill or drag-down highlighted in How to use CONCATENATE in Google Sheets section.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/concatenate-google-sheets-join-result.webp” alt=”JOIN alternative to CONCATENATE \u2014 full names returned by JOIN” title_text=”Full names returned by JOIN” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The CONCATENATE function in Google Sheets is a great tool to use when you need to organize or manage your data; not only can it make your spreadsheet easier to understand, but it can also add important context to your groups of data.<\/p>\n Although there are alternatives to the CONCATENATE function, such as using the ampersand (&) or the JOIN function, the CONCATENATE function offers more flexibility and complexity in your actions. Not only can you combine cells containing text, but also CONCATENATE a date, numbers, or other formats.<\/p>\n What\u2019s more, you can combine the CONCATENATE function with other complex formulas like the IF formula, to create complex conditions to organize your data.<\/p>\n Looking for more information on how to better combine, transfer or reference your spreadsheet data? Take a look at our related articles:<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Com a fun\u00e7\u00e3o CONCATENATE, voc\u00ea combina facilmente o conte\u00fado de c\u00e9lulas diferentes. Veja como usar CONCATENATE no Google Sheets.<\/p>","protected":false},"author":2,"featured_media":262497,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[],"class_list":["post-262477","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/262477","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=262477"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/262477\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/262497"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=262477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=262477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=262477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}How to CONCATENATE cells with spaces in Google Sheets?<\/h2>\n
How to CONCATENATE cells with commas in Google Sheets?<\/h2>\n
How to CONCATENATE cells with separators in Google Sheets?<\/h2>\n
How to combine multiple columns using CONCATENATE?<\/h2>\n
Conditional concatenate using IF formula in Google Sheets?<\/h2>\n
Alternatives to the CONCATENATE function: ampersand and JOIN<\/h2>\n
CONCATENATE alternative: Use ampersand (&) in Google Sheets<\/h3>\n
CONCATENATE alternative: Use the JOIN function in Google Sheets<\/h3>\n
Conclusion<\/h2>\n
\n