{"id":2184,"date":"2025-04-03T14:32:56","date_gmt":"2025-04-03T07:32:56","guid":{"rendered":"https:\/\/siammakemoney.com\/?p=2184"},"modified":"2026-03-09T17:20:27","modified_gmt":"2026-03-09T10:20:27","slug":"google-sheets-formula","status":"publish","type":"post","link":"https:\/\/siammakemoney.com\/en\/google-sheets-formula\/","title":{"rendered":"Including 22 secret formulas, Google Sheet functions that you didn&#039;t know before\ud83e\udd10"},"content":{"rendered":"<h2 class=\"wp-block-heading has-text-color has-link-color wp-elements-cb2a60e1c4ff1f9b8ed249e0e1771890\" style=\"color:#e36d27;font-size:28px\">Useful Google Sheet formulas for use<\/h2>\n\n\n\n<p>Google Sheet formulas create graphs, translate intra-cell, merge text in multiple cells, display images from URLs, search and filter data like SQL, fetch data from other Google Sheets, translate intra-cell, display images from URLs, display current date and time, randomize numbers, capitalize first letter, insert links into text, fetch website favicon, and more.<\/p>\n\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h2 class=\"wp-block-heading has-green-color has-text-color has-link-color wp-elements-f27e69389ae46bec42645d0cb3acc625\" style=\"font-size:27px\">1. ARRAYFORMULA \u2013 Work with multiple cells simultaneously.<\/h2>\n\n\n\n<p><strong>formula:<\/strong> <\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-4e3b2ea79558fcf88c1b9eab7a529b4b\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=ARRAYFORMULA(A2:A10 * B2:B10)<\/code><\/pre>\n\n\n\n<p><strong>Usage:<\/strong> Allows you to calculate values \u200b\u200bin multiple cells using a single formula, instead of dragging and copying the formula to every row.<\/p>\n\n\n<style scoped>\n            .gc-box{margin-bottom:30px;padding:20px;border-left:5px solid transparent;line-height:24px}.gc-box .label-info{background-color:#5bc0de;display:inline-block;margin:0 5px 10px 0;padding:3px 6px;font-size:75%;font-weight:700;color:#fff;text-align:center;white-space:nowrap;vertical-align:baseline;border-radius:.25em;line-height:14px}.gc-box.green_type{color:#3c763d;background-color:#dff0d8;border-color:#cae6be}.gc-box.blue_type{color:#31708f;background-color:#d9edf7;border-color:#bcdff1}.gc-box.red_type{color:#a94442;background-color:#f2dede;border-color:#e8c4c4}.gc-box.grey_type{background:#ddd;border-color:#ccc;color:#444}.gc-box.info_type{color:#155724;background-color:#d4edda;border-color:#c3e6cb}.gc-box.info_type svg{fill:#30a030}.gc-box.download_type{color:#004085;background-color:#cce5ff;border-color:#b8daff}.gc-box.download_type svg{fill:#3a9aff}.gc-box.update_type{color:#004458;background-color:#d9edf7;border:1px solid #bce8f1}.gc-box.notice_type{color:#856404;background-color:#fff3cd;border-color:#ffeeba}.gc-box.notice_type svg{fill:#f7a000}.gc-box.error_type{color:#721c24;background-color:#f8d7da;border-color:#f5c6cb}.gc-box.error_type svg{fill:#c70000}.gc-box.border_type{border:2px solid #ddd}.gc-box.icon_type{display:flex}.gc-box.icon_type .gc-box-icon{width:28px}.gc-box.icon_type .gc-box-text{flex-grow:1;margin:0 15px}.gc-box-text > *{margin-bottom: 20px;}\n        .gc-box-text > *:last-child{margin-bottom:0}        \n        <\/style><div class=\"gc-box green_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<p><strong>formula:<\/strong> ARRAYFORMULA in Google Sheets is used to enable formulas to work on a range of cells (multiple rows or columns) simultaneously. Normally, a formula works on a single cell, but ARRAYFORMULA allows a formula to automatically calculate for an entire column. For example, =ARRAYFORMULA(A1:A + B1:B) will add values \u200b\u200bfrom columns A and B in every row without having to drag the formula down, making it more convenient and reducing the time it takes to copy formulas.<\/p>\n\n<\/div>\n\t\t<\/div>\n<\/div>\n\t\t<\/div>\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h2 class=\"wp-block-heading has-green-color has-text-color has-link-color wp-elements-729cd1312556372cce169659d9ef4494\" style=\"font-size:28px\">2. SPARKLINE \u2013 Create a small graph in a single cell.<\/h2>\n\n\n\n<p><strong>formula:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-78798d0aab90e6f48a4a1a07f65b8473\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=SPARKLINE(A1:A10)<\/code><\/pre>\n\n\n\n<p><strong>Usage:<\/strong> Used to create small graphs in a single cell, ideal for summarizing trends in data.<\/p>\n\n\n<div class=\"gc-box green_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<p><strong>formula:<\/strong> SPARKLINE in Google Sheets is used to create small graphs within a single cell to show simple trends in data such as lines, columns, areas, candlesticks, etc. For example, =SPARKLINE(A1:A10) creates a line graph from the values \u200b\u200bin the range A1 to A10, and can be further styled, such as =SPARKLINE(A1:A10, {\u201ccharttype\u201d, \u201ccolumn\u201d; \u201ccolor\u201d, \u201cblue\u201d}) to change it to a blue bar graph, making it easy to quickly see trends in your data in a small area.<\/p>\n\n<\/div>\n\t\t<\/div>\n<\/div>\n\t\t<\/div>\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h2 class=\"wp-block-heading has-green-color has-text-color has-link-color wp-elements-e6fe484e36d99fc364a1fad8ec4d03b4\" style=\"font-size:28px\">3. QUERY \u2013 Search and filter data like SQL.<\/h2>\n\n\n\n<p><strong>formula:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-8e708ffd23585dba6defe039d6279fe9\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=QUERY(A1:D100, \"SELECT A, B WHERE C &gt; 50\", 1)<\/code><\/pre>\n\n\n\n<p><strong>Usage:<\/strong> It allows you to filter and retrieve data like a SQL query without the need for multiple filters.<\/p>\n\n\n<div class=\"gc-box green_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<p><strong>formula:<\/strong> QUERY in Google Sheets is a function that helps you filter, sort, and calculate data from a range of cells using a SQL-like command. For example, =QUERY(A1:C10, \u201cSELECT A, B WHERE C &gt; 50 ORDER BY B DESC\u201d, 1) selects columns A and B from the range A1:C10, filters only the rows where column C&#039;s value is greater than 50, and sorts B in descending order (DESC), making data analysis easier and more flexible.<\/p>\n\n<\/div>\n\t\t<\/div>\n<\/div>\n\t\t<\/div>\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h2 class=\"wp-block-heading has-green-color has-text-color has-link-color wp-elements-edb7672e35c11215531db0e9692bc13e\" style=\"font-size:27px\">4. IMPORTRANGE \u2013 Pull data from another Google Sheet.<\/h2>\n\n\n\n<p><strong>formula:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-3e6656b13c3bbb2e984083189a1e1a65\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=IMPORTRANGE(\"URL Google\", \"Sheet1!A1:D10\")<\/code><\/pre>\n\n\n\n<p><strong>Usage:<\/strong> Automatically import data from other spreadsheets for collaborative use.<\/p>\n\n\n<div class=\"gc-box green_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<p><strong>formula:<\/strong> IMPORTRANGE in Google Sheets is used to fetch data from another Google Sheets file by specifying a link and a cell range, such as: <code>=IMPORTRANGE(&#034;URL_source_sheet&#034;, &#034;Sheet1!A1:B10&#034;)<\/code> It will import data from the range A1:B10 of the sheet named \u201cSheet1\u201d in a file with the source sheet URL link, which allows for real-time linking and updating of data across files.<\/p>\n\n<\/div>\n\t\t<\/div>\n<\/div>\n\t\t<\/div>\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h2 class=\"wp-block-heading has-green-color has-text-color has-link-color wp-elements-69462b993205a7fec6ba02e0e660f2eb\" style=\"font-size:28px\">5. GOOGLETRANSLATE \u2013 Translate language within cells.<\/h2>\n\n\n\n<p><strong>formula:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-93cf1e83a05e835f9e1efa1ffc03d3c9\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=GOOGLETRANSLATE(A2, \"en\", \"th\")<\/code><\/pre>\n\n\n\n<p><strong>Usage:<\/strong> Can be used to translate text in cells from English to Thai or other languages.<\/p>\n\n\n<div class=\"gc-box green_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<p><strong>formula:<\/strong> GOOGLETRANSLATE in Google Sheets can be used to automatically translate text from one language to another, such as: <code>=GOOGLETRANSLATE(A1, &#034;en&#034;, &#034;th&#034;)<\/code> Will put the text in cell A1 which is in English (<code>&#034;in&#034;<\/code>) Translate into Thai (<code>&#034;th&#034;<\/code>) and if used <code>&#034;auto&#034;<\/code> Instead of the source language, such as <code>=GOOGLETRANSLATE(A1, &#034;auto&#034;, &#034;th&#034;)<\/code> The system will automatically detect the source language, making translating text in sheets easy and fast! \ud83c\udf0d\u2728<\/p>\n\n<\/div>\n\t\t<\/div>\n<\/div>\n\t\t<\/div>\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h2 class=\"wp-block-heading has-green-color has-text-color has-link-color wp-elements-f0d3abd68c50e0718423e007c4a4c6b6\" style=\"font-size:28px\">6. UNIQUE \u2013 Remove duplicate values<\/h2>\n\n\n\n<p><strong>formula:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-faf919575067ca37430e6e15b7afa8ee\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=UNIQUE(A2:A100)<\/code><\/pre>\n\n\n\n<p><strong>Usage:<\/strong> Help remove duplicate values \u200b\u200bin a column and display only unique values.<\/p>\n\n\n<div class=\"gc-box green_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<p><strong>formula:<\/strong> UNIQUE in Google Sheets is used to filter data to only unique values \u200b\u200bfrom a range. For example, =UNIQUE(A1:A10) will pull out the unique values \u200b\u200bfrom the range A1 to A10, so you only see the unique data in that column. This is useful for working with data that you want to show only unique values, such as a unique list of names or non-duplicating lists.<\/p>\n\n<\/div>\n\t\t<\/div>\n<\/div>\n\t\t<\/div>\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h2 class=\"wp-block-heading has-green-color has-text-color has-link-color wp-elements-1d41975719360fbf7bae24dab80f757a\" style=\"font-size:28px\">7. SORT \u2013 Automatically sort data<\/h2>\n\n\n\n<p><strong>formula:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-435f78f3f6b1392a7d69999ec9ec7162\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=SORT(A2:B100, 1, TRUE)<\/code><\/pre>\n\n\n\n<p><strong>Usage:<\/strong> Automatically sort data by specified columns.<\/p>\n\n\n<div class=\"gc-box green_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<p><strong>formula:<\/strong> SORT in Google Sheets is used to sort data in any order you want, such as ascending or descending. It can be used with both numbers and text. For example, =SORT(A1:B10, 1, TRUE) sorts the data in the range A1:B10 in ascending order (set TRUE for ascending order). To sort in descending order, use FALSE instead of TRUE. This makes organizing your data quick and easy.<\/p>\n\n<\/div>\n\t\t<\/div>\n<\/div>\n\t\t<\/div>\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h2 class=\"wp-block-heading has-green-color has-text-color has-link-color wp-elements-5bbbce60426cb509c77dfaa1496d6f78\" style=\"font-size:27px\">8. TEXTJOIN \u2013 Combine text in multiple cells using delimiters.<\/h2>\n\n\n\n<p><strong>formula:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-912e3183895b701b14a42fd5fbc626f7\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=TEXTJOIN(\", \", TRUE, A2:A10)<\/code><\/pre>\n\n\n\n<p><strong>Usage:<\/strong> Used to combine text from multiple cells into one text with a delimiter such as a comma or space.<\/p>\n\n\n<div class=\"gc-box green_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<p><strong>formula:<\/strong> TEXTJOIN in Google Sheets is used to combine text from multiple cells or ranges of data together. You can specify a delimiter between the texts, for example =TEXTJOIN(\u201c, \u201c, TRUE, A1:A5) will combine the text from A1 to A5 with \u201c, \u201d as the delimiter between the texts. If there is a blank value in the cell, it will be ignored (if TRUE is used). For example, the result might be \u201capple, banana, orange\u201d, which helps you to combine text easily and organize it better.<\/p>\n\n<\/div>\n\t\t<\/div>\n<\/div>\n\t\t<\/div>\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h2 class=\"wp-block-heading has-green-color has-text-color has-link-color wp-elements-b03d46afcf8f4c7eaf42f6301c497f20\" style=\"font-size:28px\">9. SEQUENCE \u2013 Automatically generate a number sequence.<\/h2>\n\n\n\n<p><strong>formula:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-100524f35a5d6a0e3df70d8537764ce5\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=SEQUENCE(10, 1, 1, 1)<\/code><\/pre>\n\n\n\n<p><strong>Usage:<\/strong> Help generate automatic number sequences in the desired quantity.<\/p>\n\n\n<div class=\"gc-box green_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<p><strong>formula:<\/strong> SEQUENCE in Google Sheets is used to automatically create a number sequence in a range of cells. For example, =SEQUENCE(5) \u200b\u200bcreates a sequence from 1 to 5 in a single row, while =SEQUENCE(5, 2) creates a sequence of 5 rows and 2 columns. You can further customize it, for example, use =SEQUENCE(5, 1, 10, 2) which starts at 10 and increments by 2 until you reach 10 rows:<br>10, 12, 14, 16, 18<\/p>\n\n\n\n<p>This function is suitable for creating sequences of numbers or data that increase in an orderly manner.<\/p>\n\n<\/div>\n\t\t<\/div>\n<\/div>\n\t\t<\/div>\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h2 class=\"wp-block-heading has-green-color has-text-color has-link-color wp-elements-50755ce759ab7eef6a06c0a0732c653b\" style=\"font-size:28px\">10. IMAGE \u2013 Show images from URL.<\/h2>\n\n\n\n<p><strong>formula:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-5c976cf616db00bf1eca7ca5ffe0f9d3\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=IMAGE(\"https:\/\/example.com\/image.jpg\")<\/code><\/pre>\n\n\n\n<p><strong>Usage:<\/strong> Enables displaying images from URLs directly in cells in Google Sheets.<\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-0f3537351938ef26388925e28e2ff036\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=IMAGE(B1)<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>If column B contains image links, such as: <code>https:\/\/example.com\/image.jpg<\/code><\/li>\n\n\n\n<li>This formula will extract the URL from cell B1 and display the image in that cell.<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-aa1a39c6e2add223db603ff0d3d310ba\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=IMAGE(B1, 4, 100, 100)<\/code><\/pre>\n\n\n\n<p>Resize the image (if necessary)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><code>4<\/code><\/strong> = Customize size<\/li>\n\n\n\n<li><strong><code>100<\/code><\/strong> = Width 100 pixels<\/li>\n\n\n\n<li><strong><code>100<\/code><\/strong> = Height 100 pixels<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-2c4abac128445e7bfc547a8b013222b6\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=ARRAYFORMULA(IF(B1:B&lt;&gt;\"\", IMAGE(B1:B), \"\"))<\/code><\/pre>\n\n\n\n<p>If you want to automatically display a picture for every row, use this formula in cell C1:<\/p>\n\n\n<div class=\"gc-box green_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<p><strong>formula:<\/strong> IMAGE in Google Sheets is used to display images from a URL or from a file in Google Drive within your cells, without using a separate application. This function allows you to display images conveniently and easily in Google Sheets.<\/p>\n\n<\/div>\n\t\t<\/div>\n<\/div>\n\t\t<\/div>\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h2 class=\"wp-block-heading has-green-color has-text-color has-link-color wp-elements-d7c8a4b4316b6d97d929401ab17b620c\" style=\"font-size:28px\">11. TRANSPOSE \u2013 Toggle rows into columns.<\/h2>\n\n\n\n<p><strong>formula:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-59677ec042078e40f23acd78471c5cdf\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=TRANSPOSE(A1:E1)<\/code><\/pre>\n\n\n\n<p><strong>Usage:<\/strong> Use to switch the position of data from row to column or from column to row.<\/p>\n\n\n<div class=\"gc-box green_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<p><strong>formula:<\/strong> TRANSPOSE in Google Sheets is used to change the rows and columns of data. For example, if you have data in a range of rows (horizontal), you can use TRANSPOSE to change it to columns (vertical), and vice versa. This function is useful when you want to quickly switch data between rows and columns.<\/p>\n\n<\/div>\n\t\t<\/div>\n<\/div>\n\t\t<\/div>\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h2 class=\"wp-block-heading has-green-color has-text-color has-link-color wp-elements-d74e6ca57954ba9a07273ad82dd75480\" style=\"font-size:28px\">12. CONCATENATE \u2013 Combines text from multiple cells.<\/h2>\n\n\n\n<p><strong>formula:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-db24017795a4238924467214a22e1c96\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=CONCATENATE(A1, \" \", B1)<\/code><\/pre>\n\n\n\n<p><strong>Usage:<\/strong> Help me combine values \u200b\u200bfrom multiple cells into one text.<\/p>\n\n\n<div class=\"gc-box green_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<p><strong>formula:<\/strong> CONCATENATE \u0e43\u0e19 Google \u0e0a\u0e35\u0e15\u0e43\u0e0a\u0e49\u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e23\u0e27\u0e21\u0e02\u0e49\u0e2d\u0e04\u0e27\u0e32\u0e21\u0e08\u0e32\u0e01\u0e2b\u0e25\u0e32\u0e22\u0e40\u0e0b\u0e25\u0e25\u0e4c\u0e40\u0e02\u0e49\u0e32\u0e14\u0e49\u0e27\u0e22\u0e01\u0e31\u0e19 \u0e40\u0e0a\u0e48\u0e19 \u0e16\u0e49\u0e32\u0e04\u0e38\u0e13\u0e21\u0e35\u0e04\u0e33\u0e27\u0e48\u0e32 &#8220;Hello&#8221; \u0e43\u0e19\u0e40\u0e0b\u0e25\u0e25\u0e4c A1 \u0e41\u0e25\u0e30 &#8220;World&#8221; \u0e43\u0e19\u0e40\u0e0b\u0e25\u0e25\u0e4c B1 \u0e2a\u0e39\u0e15\u0e23 =CONCATENATE(A1, &#8221; &#8220;, B1) \u0e08\u0e30\u0e23\u0e27\u0e21\u0e02\u0e49\u0e2d\u0e04\u0e27\u0e32\u0e21\u0e17\u0e31\u0e49\u0e07\u0e2a\u0e2d\u0e07\u0e40\u0e1b\u0e47\u0e19 &#8220;Hello World&#8221; \u0e42\u0e14\u0e22\u0e17\u0e35\u0e48\u0e04\u0e38\u0e13\u0e2a\u0e32\u0e21\u0e32\u0e23\u0e16\u0e40\u0e1e\u0e34\u0e48\u0e21\u0e15\u0e31\u0e27\u0e04\u0e31\u0e48\u0e19\u0e23\u0e30\u0e2b\u0e27\u0e48\u0e32\u0e07\u0e02\u0e49\u0e2d\u0e04\u0e27\u0e32\u0e21\u0e44\u0e14\u0e49 \u0e40\u0e0a\u0e48\u0e19 \u0e0a\u0e48\u0e2d\u0e07\u0e27\u0e48\u0e32\u0e07 (\u0e43\u0e0a\u0e49 &#8221; &#8220;), \u0e40\u0e04\u0e23\u0e37\u0e48\u0e2d\u0e07\u0e2b\u0e21\u0e32\u0e22\u0e08\u0e38\u0e25\u0e20\u0e32\u0e04 \u0e2b\u0e23\u0e37\u0e2d\u0e2d\u0e37\u0e48\u0e19 \u0e46 \u0e15\u0e32\u0e21\u0e15\u0e49\u0e2d\u0e07\u0e01\u0e32\u0e23 \u0e1f\u0e31\u0e07\u0e01\u0e4c\u0e0a\u0e31\u0e19\u0e19\u0e35\u0e49\u0e17\u0e33\u0e43\u0e2b\u0e49\u0e01\u0e32\u0e23\u0e23\u0e27\u0e21\u0e02\u0e49\u0e2d\u0e04\u0e27\u0e32\u0e21\u0e08\u0e32\u0e01\u0e2b\u0e25\u0e32\u0e22\u0e40\u0e0b\u0e25\u0e25\u0e4c\u0e01\u0e25\u0e32\u0e22\u0e40\u0e1b\u0e47\u0e19\u0e40\u0e23\u0e37\u0e48\u0e2d\u0e07\u0e07\u0e48\u0e32\u0e22\u0e41\u0e25\u0e30\u0e2a\u0e30\u0e14\u0e27\u0e01<\/p>\n\n<\/div>\n\t\t<\/div>\n<\/div>\n\t\t<\/div>\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h2 class=\"wp-block-heading has-green-color has-text-color has-link-color wp-elements-0e90475f84bc40f6df588c69face1214\" style=\"font-size:28px\">13. NOW &amp; TODAY \u2013 Displays the current date and time.<\/h2>\n\n\n\n<p><strong>formula:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-d1a3a4c62a8b40e083fdefb193086500\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=NOW()<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-346543cd940e46fd66f0075d00846d0d\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=TODAY()<\/code><\/pre>\n\n\n\n<p><strong>Usage:<\/strong> NOW() is used to display the current date and time. TODAY() is used to display the current date without time.<\/p>\n\n\n<div class=\"gc-box green_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<p><strong>formula:<\/strong> NOW and TODAY in Google Sheets are used to automatically display the current date and time:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><code>NOW()<\/code><\/strong>: will show the current date and time, such as <code>=NOW()<\/code> \u0e08\u0e30\u0e41\u0e2a\u0e14\u0e07\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\u0e41\u0e25\u0e30\u0e40\u0e27\u0e25\u0e32\u0e40\u0e0a\u0e48\u0e19 &#8220;2025-04-03 12:30:45&#8221; (\u0e02\u0e36\u0e49\u0e19\u0e2d\u0e22\u0e39\u0e48\u0e01\u0e31\u0e1a\u0e40\u0e27\u0e25\u0e32\u0e17\u0e35\u0e48\u0e04\u0e38\u0e13\u0e43\u0e0a\u0e49\u0e2a\u0e39\u0e15\u0e23)<\/li>\n\n\n\n<li><strong><code>TODAY()<\/code><\/strong>: It will only show the current date without time, such as: <code>=TODAY()<\/code> \u0e08\u0e30\u0e43\u0e2b\u0e49\u0e1c\u0e25\u0e25\u0e31\u0e1e\u0e18\u0e4c\u0e40\u0e1b\u0e47\u0e19 &#8220;2025-04-03&#8221; \u0e42\u0e14\u0e22\u0e2d\u0e31\u0e15\u0e42\u0e19\u0e21\u0e31\u0e15\u0e34<\/li>\n<\/ul>\n\n\n\n<p>Both functions update the data every time the sheet is edited or reopened, making it easy to use current date and time data. \ud83c\udf89<\/p>\n\n<\/div>\n\t\t<\/div>\n<\/div>\n\t\t<\/div>\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h2 class=\"wp-block-heading has-green-color has-text-color has-link-color wp-elements-308762d4bd7c54748fd00d5ba99e4189\" style=\"font-size:28px\">14. RAND &amp; RANDBETWEEN \u2013 Random Numbers<\/h2>\n\n\n\n<p><strong>formula:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-1d639e89ee0d34f6b9144a7f0348c83b\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=RAND()<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-daf93558f9eada5d42a5cdf127fbf270\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=RANDBETWEEN(1, 100)<\/code><\/pre>\n\n\n\n<p><strong>Usage:<\/strong> RAND() generates a random number between 0 and 1. RANDBETWEEN(x, y) generates a random number between x and y.<\/p>\n\n\n<div class=\"gc-box green_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<p><strong>formula:<\/strong>  <strong><code>RAND()<\/code><\/strong> and <strong><code>RANDBETWEEN()<\/code><\/strong> In Google Sheets used for generating random numbers:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><code>RAND()<\/code><\/strong>: This function will generate a random number between 0 and 1 (e.g. 0.12345) when used. <code>=RAND()<\/code> You will get a different random number every time you recalculate in the sheet.<\/li>\n\n\n\n<li><strong><code>RANDBETWEEN()<\/code><\/strong>: Used to generate random numbers in a specified range, such as: <code>=RANDBETWEEN(1, 100)<\/code> It will generate a random number between 1 and 100, including range numbers (1 and 100), giving you more flexibility when you need a custom range of numbers.<\/li>\n<\/ul>\n\n\n\n<p>Both functions will automatically change their values \u200b\u200bwhen recalculated in the sheet\ud83c\udf1f<\/p>\n\n<\/div>\n\t\t<\/div>\n<\/div>\n\t\t<\/div>\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h2 class=\"wp-block-heading has-green-color has-text-color has-link-color wp-elements-5c3ca2d192163c6a7ec9a6377c0653be\" style=\"font-size:28px\">15. SPLIT \u2013 Splits text into multiple columns.<\/h2>\n\n\n\n<p><strong>formula:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-db173dc75f41f9b0cf32c5b01c7910a8\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=SPLIT(A1, \", \")<\/code><\/pre>\n\n\n\n<p>Use to separate text with delimiters such as commas or spaces.<\/p>\n\n\n<div class=\"gc-box green_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<p><strong>formula:<\/strong> SPLIT() in Google Sheets is used to split text in a cell into multiple parts using a specified delimiter. For example, if you have the text in cell A1 that is \u201cApple, Banana, Orange\u201d and you use the formula =SPLIT(A1, \u201c, \u201c), it will split the text into multiple cells separated by a comma and a space. <\/p>\n\n\n\n<p>You can use a variety of delimiters, such as commas, spaces, or even other characters as needed, making it easy to manage multi-part data.<\/p>\n\n<\/div>\n\t\t<\/div>\n<\/div>\n\t\t<\/div>\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h2 class=\"wp-block-heading has-green-color has-text-color has-link-color wp-elements-b6f81c31cfff9e29c3a78d6be8cecb60\" style=\"font-size:27px\">16. REGEXEXTRACT \u2013 Extract data according to the specified format.<\/h2>\n\n\n\n<p><strong>formula:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-bdc71cafd94cae8e97140105f589a9ad\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=REGEXEXTRACT(A1, \"&#91;0-9]+\")<\/code><\/pre>\n\n\n\n<p>Use to extract only numbers from text.<\/p>\n\n\n<div class=\"gc-box green_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<p><strong>formula:<\/strong> REGEXEXTRACT() in Google Sheets is used to extract data that matches a specific pattern from text. For example, if you want to extract email addresses from the text contained in cell A1, which might be \u201cEmail: john@example.com\u201d, the formula =REGEXEXTRACT(A1, \u201c\\S+@\\S+\u201d) will extract only the email address \u201cjohn@example.com\u201d. By using a Regular Expression (regex) to specify a specific pattern, such as an email address, phone number, or specific text, extracting the desired data from text is easy and precise!<\/p>\n\n<\/div>\n\t\t<\/div>\n<\/div>\n\t\t<\/div>\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h2 class=\"wp-block-heading has-green-color has-text-color has-link-color wp-elements-596bf4f2fcafffbbc237a8889550fd22\" style=\"font-size:27px\">17. SUBSTITUTE\u2013 Replace any word, symbol, or other character.<\/h2>\n\n\n\n<p><strong>formula:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-671678b91bc1d72e793a4227b6a8e9a5\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=SUBSTITUTE(B2, \"-\", \".\")<\/code><\/pre>\n\n\n\n<p>\u0e2a\u0e39\u0e15\u0e23\u0e19\u0e35\u0e49\u0e08\u0e30\u0e15\u0e23\u0e27\u0e08\u0e2a\u0e2d\u0e1a\u0e40\u0e0b\u0e25\u0e25\u0e4c B2 \u0e41\u0e25\u0e30\u0e41\u0e17\u0e19\u0e17\u0e35\u0e48\u0e40\u0e04\u0e23\u0e37\u0e48\u0e2d\u0e07\u0e2b\u0e21\u0e32\u0e22 &#8220;-&#8221; \u0e17\u0e38\u0e01\u0e15\u0e31\u0e27\u0e14\u0e49\u0e27\u0e22 &#8220;.&#8221; \u0e40\u0e1b\u0e25\u0e35\u0e48\u0e22\u0e19\u0e04\u0e33\u0e41\u0e25\u0e30\u0e40\u0e0b\u0e25\u0e25\u0e4c \u0e15\u0e32\u0e21\u0e15\u0e49\u0e2d\u0e07\u0e01\u0e32\u0e23<\/p>\n\n\n<div class=\"gc-box green_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<p><strong>formula:<\/strong> <strong><code>SUBSTITUTE()<\/code><\/strong> \u0e43\u0e19 Google \u0e0a\u0e35\u0e15\u0e43\u0e0a\u0e49\u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e41\u0e17\u0e19\u0e17\u0e35\u0e48\u0e02\u0e49\u0e2d\u0e04\u0e27\u0e32\u0e21\u0e1a\u0e32\u0e07\u0e2a\u0e48\u0e27\u0e19\u0e20\u0e32\u0e22\u0e43\u0e19\u0e02\u0e49\u0e2d\u0e04\u0e27\u0e32\u0e21\u0e17\u0e35\u0e48\u0e21\u0e35\u0e2d\u0e22\u0e39\u0e48\u0e41\u0e25\u0e49\u0e27 \u0e42\u0e14\u0e22\u0e44\u0e21\u0e48\u0e15\u0e49\u0e2d\u0e07\u0e41\u0e01\u0e49\u0e44\u0e02\u0e02\u0e49\u0e2d\u0e04\u0e27\u0e32\u0e21\u0e17\u0e31\u0e49\u0e07\u0e2b\u0e21\u0e14 \u0e40\u0e0a\u0e48\u0e19 \u0e16\u0e49\u0e32\u0e04\u0e38\u0e13\u0e21\u0e35\u0e02\u0e49\u0e2d\u0e04\u0e27\u0e32\u0e21\u0e43\u0e19\u0e40\u0e0b\u0e25\u0e25\u0e4c A1 \u0e04\u0e37\u0e2d &#8220;Hello World&#8221; \u0e41\u0e25\u0e30\u0e15\u0e49\u0e2d\u0e07\u0e01\u0e32\u0e23\u0e41\u0e17\u0e19\u0e17\u0e35\u0e48\u0e04\u0e33\u0e27\u0e48\u0e32 &#8220;World&#8221; \u0e14\u0e49\u0e27\u0e22 &#8220;Everyone&#8221; \u0e43\u0e0a\u0e49\u0e2a\u0e39\u0e15\u0e23\u0e19\u0e35\u0e49:<\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-fcc19ba6a8a32c9331aa959ca6d61b70\" data-no-translation=\"\" data-no-auto-translation=\"\"><code><code>=SUBSTITUTE(A1, \"World\", \"Everyone\")\n<\/code><\/code><\/pre>\n\n\n\n<p>\u0e1c\u0e25\u0e25\u0e31\u0e1e\u0e18\u0e4c\u0e08\u0e30\u0e40\u0e1b\u0e47\u0e19 &#8220;Hello Everyone&#8221; \u0e0b\u0e36\u0e48\u0e07\u0e08\u0e30\u0e40\u0e1b\u0e25\u0e35\u0e48\u0e22\u0e19\u0e04\u0e33\u0e27\u0e48\u0e32 &#8220;World&#8221; \u0e40\u0e1b\u0e47\u0e19 &#8220;Everyone&#8221; \u0e42\u0e14\u0e22\u0e2d\u0e31\u0e15\u0e42\u0e19\u0e21\u0e31\u0e15\u0e34 \u0e16\u0e49\u0e32\u0e04\u0e38\u0e13\u0e15\u0e49\u0e2d\u0e07\u0e01\u0e32\u0e23\u0e41\u0e17\u0e19\u0e17\u0e35\u0e48\u0e2b\u0e25\u0e32\u0e22\u0e04\u0e23\u0e31\u0e49\u0e07\u0e01\u0e47\u0e2a\u0e32\u0e21\u0e32\u0e23\u0e16\u0e23\u0e30\u0e1a\u0e38\u0e2b\u0e21\u0e32\u0e22\u0e40\u0e25\u0e02\u0e04\u0e23\u0e31\u0e49\u0e07\u0e17\u0e35\u0e48\u0e15\u0e49\u0e2d\u0e07\u0e01\u0e32\u0e23\u0e41\u0e17\u0e19\u0e17\u0e35\u0e48\u0e44\u0e14\u0e49 \u0e40\u0e0a\u0e48\u0e19 <code>SUBSTITUTE(A1, &#034;a&#034;, &#034;b&#034;, 2)<\/code> \u0e08\u0e30\u0e41\u0e17\u0e19\u0e17\u0e35\u0e48\u0e41\u0e04\u0e48\u0e04\u0e23\u0e31\u0e49\u0e07\u0e17\u0e35\u0e48 2 \u0e02\u0e2d\u0e07 &#8220;a&#8221; \u0e43\u0e19\u0e02\u0e49\u0e2d\u0e04\u0e27\u0e32\u0e21\u0e40\u0e17\u0e48\u0e32\u0e19\u0e31\u0e49\u0e19<\/p>\n\n<\/div>\n\t\t<\/div>\n<\/div>\n\t\t<\/div>\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h2 class=\"wp-block-heading has-green-color has-text-color has-link-color wp-elements-cceb7402149c11a75d7da0645ee99861\" style=\"font-size:26px\">18. CONCATENATE \u2013 Combines columns together in rows.<\/h2>\n\n\n\n<p><strong>formula:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-16a032ec3e8931afd0233b8f90d434fe\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=A1 &amp; B1 &amp; C1 &amp; D1 &amp;E1<\/code><\/pre>\n\n\n\n<p>This formula will merge the columns A1 B1 C1 D1 E1 (start with = and use &amp;). Change the columns or sort the columns as needed. Make other rows sort automatically by using the + sign below the row where the formula is entered.<\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-eb8a7ec00745d6056462a9a7a345563b\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=A2 &amp; \" message \" &amp; B2<\/code><\/pre>\n\n\n\n<p>If you want to add spaces or text between the combined values<\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-ec24e679969fa71ca8ff3dc8b1e8059e\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=CONCATENATE(A2, \" message \", B2)<\/code><\/pre>\n\n\n\n<p>Or use the function <code>CONCATENATE<\/code> With additional space:<\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-2e5b8bdb17ec34e072fcdc3b38ddf769\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=\"|\" &amp; B2<\/code><\/pre>\n\n\n\n<p>Suppose you have data in column B and you want to add a \u201c|\u201d sign before each string in column C:<\/p>\n\n\n\n<p class=\"has-orange-color has-text-color has-link-color wp-elements-4e09d8d0061f5a516370311cfc23eb92\"><strong>Increase the space between texts<\/strong><\/p>\n\n\n\n<p>Use function <code>CONCATENATE<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-23e8caa8374e3e76f614f9bd69bf3aae\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=CONCATENATE(B1, \" \", C1)<\/code><\/pre>\n\n\n\n<p>Use the symbol <code>&amp;<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-c3cd782e84783b88dd9ce72507c90b10\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=B1 &amp; \" \" &amp; C1<\/code><\/pre>\n\n\n<div class=\"gc-box green_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<p><strong>formula:<\/strong> CONCATENATE() \u0e43\u0e19 Google \u0e0a\u0e35\u0e15\u0e43\u0e0a\u0e49\u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e01\u0e32\u0e23\u0e23\u0e27\u0e21\u0e02\u0e49\u0e2d\u0e04\u0e27\u0e32\u0e21\u0e08\u0e32\u0e01\u0e2b\u0e25\u0e32\u0e22\u0e40\u0e0b\u0e25\u0e25\u0e4c\u0e2b\u0e23\u0e37\u0e2d\u0e2b\u0e25\u0e32\u0e22\u0e2a\u0e48\u0e27\u0e19\u0e40\u0e02\u0e49\u0e32\u0e14\u0e49\u0e27\u0e22\u0e01\u0e31\u0e19 \u0e40\u0e0a\u0e48\u0e19 \u0e16\u0e49\u0e32\u0e40\u0e0b\u0e25\u0e25\u0e4c A1 \u0e21\u0e35\u0e02\u0e49\u0e2d\u0e04\u0e27\u0e32\u0e21 &#8220;Hello&#8221; \u0e41\u0e25\u0e30 B1 \u0e21\u0e35\u0e02\u0e49\u0e2d\u0e04\u0e27\u0e32\u0e21 &#8220;World&#8221; \u0e2a\u0e39\u0e15\u0e23 =CONCATENATE(A1, &#8221; &#8220;, B1) \u0e08\u0e30\u0e23\u0e27\u0e21\u0e02\u0e49\u0e2d\u0e04\u0e27\u0e32\u0e21\u0e17\u0e31\u0e49\u0e07\u0e2a\u0e2d\u0e07\u0e40\u0e1b\u0e47\u0e19 &#8220;Hello World&#8221; \u0e42\u0e14\u0e22\u0e21\u0e35\u0e0a\u0e48\u0e2d\u0e07\u0e27\u0e48\u0e32\u0e07\u0e23\u0e30\u0e2b\u0e27\u0e48\u0e32\u0e07\u0e04\u0e33 \u0e0b\u0e36\u0e48\u0e07\u0e1f\u0e31\u0e07\u0e01\u0e4c\u0e0a\u0e31\u0e19\u0e19\u0e35\u0e49\u0e0a\u0e48\u0e27\u0e22\u0e43\u0e2b\u0e49\u0e04\u0e38\u0e13\u0e2a\u0e32\u0e21\u0e32\u0e23\u0e16\u0e23\u0e27\u0e21\u0e02\u0e49\u0e2d\u0e04\u0e27\u0e32\u0e21\u0e08\u0e32\u0e01\u0e2b\u0e25\u0e32\u0e22\u0e41\u0e2b\u0e25\u0e48\u0e07\u0e40\u0e02\u0e49\u0e32\u0e40\u0e1b\u0e47\u0e19\u0e02\u0e49\u0e2d\u0e04\u0e27\u0e32\u0e21\u0e40\u0e14\u0e35\u0e22\u0e27\u0e44\u0e14\u0e49\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e07\u0e48\u0e32\u0e22\u0e14\u0e32\u0e22<\/p>\n\n<\/div>\n\t\t<\/div>\n<\/div>\n\t\t<\/div>\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h2 class=\"wp-block-heading has-green-color has-text-color has-link-color wp-elements-589b4fcb66417b8a19ffd633b0264807\" style=\"font-size:26px\">19. REGEXREPLACE\u2013 Delete the \/ sign and the following words.<\/h2>\n\n\n\n<p><strong>formula:<\/strong> <\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-40165610bc1a6613c4f1cb8dfd130c0b\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=REGEXREPLACE(A1, \"\/.*\", \"\")<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>A1<\/code> is the cell where you want to delete the text.<\/li>\n\n\n\n<li><code>\/.*<\/code> This is a pattern that searches for text that contains the \/ sign and all subsequent characters.<\/li>\n\n\n\n<li><code>\"\"<\/code> It means to replace the text that matches the search pattern with blank values \u200b\u200b(remove them). You can also enter words in here.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column A (original)<\/th><th>Column B (Result)<\/th><\/tr><\/thead><tbody><tr><td>share.netnut.cn\/4f4sDx<\/td><td>share.netnut.cn<\/td><\/tr><tr><td>example.com\/page1<\/td><td>example.com<\/td><\/tr><tr><td>test.website.com\/path\/to\/page<\/td><td>test.website.com<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-9f6681dd64d9626c83f4f4492a121967\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=REGEXREPLACE(A1, \"\/.*\", \"message\")<\/code><\/pre>\n\n\n\n<p>This formula will insert the text message in place of the \/ symbol and the following words.<\/p>\n\n\n<div class=\"gc-box green_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<p><strong>formula:<\/strong> REGEXREPLACE in Google Sheets is used to replace text within cells that match a specified pattern.<\/p>\n\n\n\n<p>This function allows you to easily replace text that matches a desired format, such as numbers, letters, or special text, in Google Sheets.<\/p>\n\n<\/div>\n\t\t<\/div>\n<\/div>\n\t\t<\/div>\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h2 class=\"wp-block-heading has-green-color has-text-color has-link-color wp-elements-f8e7ef0b83c23c65cd527c52e7d9a9e7\" style=\"font-size:24px\">20. PROPER\u2013 Automatically capitalizes the first letter.<\/h2>\n\n\n\n<p><strong>formula:<\/strong> <\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-4db1871bea03887d335c80f94a2238be\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=PROPER(B1)<\/code><\/pre>\n\n\n\n<p>You can use the REGEXREPLACE function in conjunction with PROPER to remove the period (.) and the word after it, and capitalize the first letter.<\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-4e7d06ed25e7c9012d936a3f69c150a9\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=PROPER(REGEXREPLACE(B1, \"\\..*\", \"\"))<\/code><\/pre>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong><code>REGEXREPLACE(B1, &#034;\\..*&#034;, &#034;&#034;)<\/code><\/strong>\n<ul class=\"wp-block-list\">\n<li><code>\\.<\/code> \u2192 \u0e2b\u0e21\u0e32\u0e22\u0e16\u0e36\u0e07 &#8220;\u0e08\u0e38\u0e14 (<code>.<\/code>)&#8221;<\/li>\n\n\n\n<li><code>.*<\/code> \u2192 \u0e2b\u0e21\u0e32\u0e22\u0e16\u0e36\u0e07 &#8220;\u0e15\u0e31\u0e27\u0e2d\u0e31\u0e01\u0e29\u0e23\u0e43\u0e14\u0e46 \u0e17\u0e35\u0e48\u0e15\u0e32\u0e21\u0e21\u0e32\u0e2b\u0e25\u0e31\u0e07\u0e08\u0e32\u0e01\u0e08\u0e38\u0e14&#8221;<\/li>\n\n\n\n<li><strong>Replace all with empty values \u200b\u200b(<code>\"\"<\/code>)<\/strong> \u2192 Delete everything from the point onwards.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong><code>PROPER(...)<\/code><\/strong>\n<ul class=\"wp-block-list\">\n<li>Used to make the first letter a <strong>Capital letters<\/strong><\/li>\n\n\n\n<li>such as <code>&#034;soax&#034;<\/code> \u2192 <code>&#034;Soax&#034;<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<p><strong>Sample results<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column B (original)<\/th><th>Column C (Result)<\/th><\/tr><\/thead><tbody><tr><td>soax.com<\/td><td>Soax<\/td><\/tr><tr><td>example.net<\/td><td>Example<\/td><\/tr><tr><td>google.co.uk<\/td><td>Google<\/td><\/tr><tr><td>test.website<\/td><td>Test<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n<div class=\"gc-box green_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<p><strong>formula:<\/strong> <strong><code>PROPER()<\/code><\/strong> In Google Sheets, it is used to capitalize the first letter of each word and lowercase the rest of the letters. For example, if cell A1 contains the text \u201chello world\u201d, the formula <code>=PROPER(A1)<\/code> It will automatically change the text to \u201cHello World,\u201d which helps make multi-word text look cleaner and more organized.<\/p>\n\n<\/div>\n\t\t<\/div>\n<\/div>\n\t\t<\/div>\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h2 class=\"wp-block-heading has-green-color has-text-color has-link-color wp-elements-60a260262ec0f607a83b6f946b2bbab2\" style=\"font-size:24px\">21. HYPERLINK \u2013 Insert a link into the column text. <\/h2>\n\n\n\n<p><strong>formula:<\/strong> <\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-6a662560963ef66d2e87ad3a8a8eef42\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=HYPERLINK(C1, B1)<\/code><\/pre>\n\n\n\n<p>This formula will make the text in B1 a link using the URL from C1.<\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-74ced1ebc2afa01fb65ce8046ed8c10f\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=HYPERLINK(C1, \"Open link\ud83d\ude80\")<\/code><\/pre>\n\n\n\n<p><strong>Sample results<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column B (Text)<\/th><th>Column C (Link)<\/th><th>Column D (Result)<\/th><\/tr><\/thead><tbody><tr><td>Google<\/td><td>https:\/\/google.com<\/td><td><a href=\"https:\/\/google.com\" target=\"_blank\" rel=\"noreferrer noopener\">Google<\/a><\/td><\/tr><tr><td>YouTube<\/td><td>https:\/\/youtube.com<\/td><td><a href=\"https:\/\/youtube.com\" target=\"_blank\" rel=\"noreferrer noopener\">YouTube<\/a><\/td><\/tr><tr><td>OpenAI<\/td><td>https:\/\/openai.com<\/td><td><a href=\"https:\/\/openai.com\" target=\"_blank\" rel=\"noreferrer noopener\">OpenAI<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Use automatic formulas for the entire column<\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-356959ab434ca40f24d8c350f6102936\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=ARRAYFORMULA(IF(B1:B&lt;&gt;\"\", HYPERLINK(C1:C, B1:B), \"\"))<\/code><\/pre>\n\n\n\n<p>You can use <strong>Google Apps Script<\/strong> To embed a direct link into column B or D<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to <strong>Extensions &gt; Apps Script<\/strong><\/li>\n\n\n\n<li>Delete the old code and insert this code:<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-e7001c1550de7c3e5c53b3934e99efda\" data-no-translation=\"\" data-no-auto-translation=\"\"><code><code>function insertHyperlinks() {\n  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();\n  var data = sheet.getDataRange().getValues();\n\n  for (var i = 1; i &lt; data.length; i++) {\n    var text = data&#91;i]&#91;1]; \n    var url = data&#91;i]&#91;2];  \n    \n    if (text &amp;&amp; url) {\n      sheet.getRange(i+1, 2).setFormula('=HYPERLINK(\"' + url + '\", \"' + text + '\")');\n    }\n  }\n}\n<\/code><\/code><\/pre>\n\n\n\n<ul start=\"3\" class=\"wp-block-list\">\n<li>press <strong>Run (\u25b6)<\/strong> To make the script work<\/li>\n\n\n\n<li>The link will now be permanently embedded in column B.<\/li>\n\n\n\n<li>You can now delete Column C! \ud83c\udf89<\/li>\n<\/ul>\n\n\n<div class=\"gc-box green_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<p><strong>formula:<\/strong> The HYPERLINK() function in Google Sheets is used to create clickable links that link text or URLs to websites or other resources. This function makes it easy and convenient to link text or data in a sheet to an external data source.<\/p>\n\n<\/div>\n\t\t<\/div>\n<\/div>\n\t\t<\/div>\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h2 class=\"wp-block-heading has-green-color has-text-color has-link-color wp-elements-cc96b744706db9c1b67d5f0f7a7d6a33\" style=\"font-size:25px\">22. Favicon \u2013 How to display the favicon of various websites.<\/h2>\n\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h3 class=\"wp-block-heading has-text-color has-link-color wp-elements-d7055f4d83d528fea84c33750347d9db\" style=\"color:#e57803;font-size:20px\">Show as url of favicon image<\/h3>\n\n\n\n<p><strong>Method 1: Use plain Google (easiest)<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-2ad8481a1e4bd44650001bb0ff82f208\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>https:&#47;&#47;www.google.com\/s2\/favicons?domain=youtube.com<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You can extract any website favicons as the image url.<\/li>\n<\/ul>\n\n\n\n<p><strong>\u0e27\u0e34\u0e18\u0e35\u0e17\u0e35\u0e48 2 \u0e43\u0e0a\u0e49 google \u0e41\u0e1a\u0e1a\u0e18\u0e23\u0e23\u0e21\u0e14\u0e32 (64&#215;64)<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-bad9d5a8e0456365d13c2bf135ada4cf\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>https:&#47;&#47;www.google.com\/s2\/favicons?sz=64&amp;domain=youtube.com<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>This formula will allow you to get the Favicon size <strong>64x64px<\/strong><\/li>\n<\/ul>\n\n<\/div>\n\t\t<\/div>\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h3 class=\"wp-block-heading has-text-color has-link-color wp-elements-8aebef00a0b36f729d932c6210351470\" style=\"color:#e57803;font-size:20px\">Show as image immediately from image URL<\/h3>\n\n\n\n<p><strong>Method 1: Using Google&#039;s Favicon API (easiest method)<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-9e69b0df7275f5a8f8d381b01e1a0529\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=IMAGE(\"https:\/\/www.google.com\/s2\/favicons?domain=youtube.com\")<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>This formula will display as a Favicon image in Google Sheets.<\/li>\n<\/ul>\n\n\n\n<p><strong>Method 2: Using Google&#039;s Favicon API (best method)<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-76583b736479d5ea685f190163555879\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=IMAGE(\"https:\/\/www.google.com\/s2\/favicons?sz=64&amp;domain=youtube.com\")<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>This formula will display as a Favicon image in google sheets. Size <strong>64x64px<\/strong> (Clearer)<\/li>\n<\/ul>\n\n<\/div>\n\t\t<\/div>\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<h3 class=\"wp-block-heading has-text-color has-link-color wp-elements-23e86fa1dee6b39df60136be5d423e99\" style=\"color:#e57803;font-size:20px\">Display as an image immediately, pulling from other forum image URLs.<\/h3>\n\n\n\n<p><strong>Method 1: Using Google&#039;s Favicon API (best method)<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-d8c7d6789bbf967adf5c171eb22af943\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=IMAGE(\"https:\/\/www.google.com\/s2\/favicons?sz=64&amp;domain=\" &amp; A2)<\/code><\/pre>\n\n\n\n<p>This formula will display as a Favicon image in google sheets. Size <strong>64x64px<\/strong> (Clearer)<\/p>\n\n\n\n<p><strong>How to use:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Enter the domain name in the column <code>A2<\/code> such as <strong>example.com<\/strong><\/li>\n\n\n\n<li>This formula will pull the Favicon size <strong>64x64px<\/strong> Come show<\/li>\n<\/ul>\n\n\n\n<p><strong>The way that <\/strong>2. Pull Favicon directly from website (if API is not available)<\/p>\n\n\n\n<pre class=\"wp-block-code has-layout-color has-primary-background-color has-text-color has-background has-link-color wp-elements-579ae3a37fbd55a6cc1b9ef49b2ef2e9\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>=IMAGE(\"https:\/\/\" &amp; A2 &amp; \"\/favicon.ico\")<\/code><\/pre>\n\n<\/div>\n\t\t<\/div>\n<\/div>\n\t\t<\/div>\n\n<style scoped>.gc-howto{margin:45px 0 30px 0;border:3px solid #e7e4df;border-top:none;position:relative;counter-reset:gchowto}.gc-howto__heading{font-size:19px;font-weight:700;line-height:20px;padding:0 15px;text-transform:uppercase}.gc-howto__title{display:flex;align-items:center;position:absolute;width:100%;top:-10px;height:22px}.gc-howto__line{flex-grow:1;height:3px;background-color:#e7e4df}.gc-howto__description{padding:35px 25px 25px 25px}.gc-howtoitem__step{position:relative;counter-increment:gchowto;padding:18px 25px}.gc-howtoitem__heading{font-weight:700;font-size:20px;line-height:24px;margin:0 0 25px 0;padding:0 0 0 50px;position:relative}.gc-howtoitem__heading:before{content:counter(gchowto);color:#fcd000;font-size:1.5rem;font-weight:700;position:absolute;--size:32px;line-height:var(--size);width:var(--size);height:var(--size);top:-5px;left:0;background:#000;border-radius:50%;text-align:center}.gc-howtoitem__content{font-size:16px;line-height:24px}<\/style><div id=\"gc-howid7c73d4\" class=\"gc-howto\" style=\"border-color:#10a399;\"><style scoped>#gc-howid7c73d4 .gc-howtoitem__heading:before{background-color:#f8f9fa;color:#10a399;}<\/style><div class=\"gc-howto__title\"><div class=\"gc-howto__line\" style=\"background-color:#10a399;\"><\/div><div class=\"gc-howto__heading\">Other recipes<\/div><div class=\"gc-howto__line\" style=\"background-color:#10a399;\"><\/div><\/div><div class=\"gc-howto__description\"><div>Google Sheets has many functions and formulas that can help you make your work more convenient and efficient. Here is a list of commonly used and useful formulas:<\/div><\/div><div id=\"gc-howid7c73d4step1\" class=\"gc-howtoitem__step\"><div class=\"gc-howtoitem__title\"><div class=\"gc-howtoitem__heading\">IF():<\/div><\/div><div class=\"gc-howtoitem__content\" ><div class=\"gc-howtoitem__text\">\u0e43\u0e0a\u0e49\u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e01\u0e32\u0e23\u0e15\u0e23\u0e27\u0e08\u0e2a\u0e2d\u0e1a\u0e40\u0e07\u0e37\u0e48\u0e2d\u0e19\u0e44\u0e02\u0e41\u0e25\u0e30\u0e04\u0e37\u0e19\u0e04\u0e48\u0e32\u0e1c\u0e25\u0e25\u0e31\u0e1e\u0e18\u0e4c\u0e15\u0e32\u0e21\u0e40\u0e07\u0e37\u0e48\u0e2d\u0e19\u0e44\u0e02\u0e17\u0e35\u0e48\u0e01\u0e33\u0e2b\u0e19\u0e14 \u0e40\u0e0a\u0e48\u0e19 =IF(A1 &gt; 10, &#8220;\u0e21\u0e32\u0e01\u0e01\u0e27\u0e48\u0e32 10&#8221;, &#8220;\u0e19\u0e49\u0e2d\u0e22\u0e01\u0e27\u0e48\u0e32\u0e2b\u0e23\u0e37\u0e2d\u0e40\u0e17\u0e48\u0e32\u0e01\u0e31\u0e1a 10&#8221;) \u0e16\u0e49\u0e32 A1 \u0e21\u0e32\u0e01\u0e01\u0e27\u0e48\u0e32 10 \u0e08\u0e30\u0e41\u0e2a\u0e14\u0e07 &#8220;\u0e21\u0e32\u0e01\u0e01\u0e27\u0e48\u0e32 10&#8221;<\/div><\/div><\/div><div id=\"gc-howid7c73d4step2\" class=\"gc-howtoitem__step\"><div class=\"gc-howtoitem__title\"><div class=\"gc-howtoitem__heading\">COUNTIF():<\/div><\/div><div class=\"gc-howtoitem__content\" ><div class=\"gc-howtoitem__text\">It is used to count the number of cells that meet a specified condition, for example =COUNTIF(A1:A10, \u201c&gt;10\u201d) will count the number of cells in the range A1:A10 that have a value greater than 10.<\/div><\/div><\/div><div id=\"gc-howid7c73d4step3\" class=\"gc-howtoitem__step\"><div class=\"gc-howtoitem__title\"><div class=\"gc-howtoitem__heading\">SUMIF():<\/div><\/div><div class=\"gc-howtoitem__content\" ><div class=\"gc-howtoitem__text\">It is used to find the sum of cells that meet a condition, for example =SUMIF(A1:A10, \u201c&gt;10\u201d) will find the sum of the values \u200b\u200bgreater than 10 in the range A1:A10.<\/div><\/div><\/div><div id=\"gc-howid7c73d4step4\" class=\"gc-howtoitem__step\"><div class=\"gc-howtoitem__title\"><div class=\"gc-howtoitem__heading\">VLOOKUP(): <\/div><\/div><div class=\"gc-howtoitem__content\" ><div class=\"gc-howtoitem__text\">It is used to look up a value in a table by looking at the first column, for example =VLOOKUP(A1, B1:C10, 2, FALSE) will look up the value from A1 in columns B1:B10 and return the matching value from column C.<\/div><\/div><\/div><div id=\"gc-howid7c73d4step5\" class=\"gc-howtoitem__step\"><div class=\"gc-howtoitem__title\"><div class=\"gc-howtoitem__heading\">INDEX(): <\/div><\/div><div class=\"gc-howtoitem__content\" ><div class=\"gc-howtoitem__text\">It is used to fetch data from a table at a specified position, for example =INDEX(B1:C10, 3, 2) will fetch values \u200b\u200bfrom row 3 and column 2 of range B1:C10.<\/div><\/div><\/div><div id=\"gc-howid7c73d4step6\" class=\"gc-howtoitem__step\"><div class=\"gc-howtoitem__title\"><div class=\"gc-howtoitem__heading\">MATCH(): <\/div><\/div><div class=\"gc-howtoitem__content\" ><div class=\"gc-howtoitem__text\">\u0e43\u0e0a\u0e49\u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e01\u0e32\u0e23\u0e04\u0e49\u0e19\u0e2b\u0e32\u0e04\u0e48\u0e32\u0e08\u0e32\u0e01\u0e0a\u0e48\u0e27\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e41\u0e25\u0e30\u0e04\u0e37\u0e19\u0e15\u0e33\u0e41\u0e2b\u0e19\u0e48\u0e07\u0e17\u0e35\u0e48\u0e1e\u0e1a \u0e40\u0e0a\u0e48\u0e19 =MATCH(&#8220;Apple&#8221;, A1:A10, 0) \u0e08\u0e30\u0e04\u0e49\u0e19\u0e2b\u0e32\u0e04\u0e33\u0e27\u0e48\u0e32 &#8220;Apple&#8221; \u0e43\u0e19\u0e0a\u0e48\u0e27\u0e07 A1:A10 \u0e41\u0e25\u0e30\u0e04\u0e37\u0e19\u0e15\u0e33\u0e41\u0e2b\u0e19\u0e48\u0e07\u0e17\u0e35\u0e48\u0e1e\u0e1a<\/div><\/div><\/div><div id=\"gc-howid7c73d4step7\" class=\"gc-howtoitem__step\"><div class=\"gc-howtoitem__title\"><div class=\"gc-howtoitem__heading\">ONLY(): <\/div><\/div><div class=\"gc-howtoitem__content\" ><div class=\"gc-howtoitem__text\">It is used to find the length of text in a cell, for example =LEN(A1) will return the number of characters in cell A1.<\/div><\/div><\/div><div id=\"gc-howid7c73d4step8\" class=\"gc-howtoitem__step\"><div class=\"gc-howtoitem__title\"><div class=\"gc-howtoitem__heading\">LEFT(): <\/div><\/div><div class=\"gc-howtoitem__content\" ><div class=\"gc-howtoitem__text\">It is used to extract text from the left side of the text, for example =LEFT(A1, 5) will extract the first 5 characters from the text in A1.<\/div><\/div><\/div><div id=\"gc-howid7c73d4step9\" class=\"gc-howtoitem__step\"><div class=\"gc-howtoitem__title\"><div class=\"gc-howtoitem__heading\">RIGHT(): <\/div><\/div><div class=\"gc-howtoitem__content\" ><div class=\"gc-howtoitem__text\">It is used to extract text from the right side of the text, for example =RIGHT(A1, 3) will extract the last 3 characters from the text in A1.<\/div><\/div><\/div><div id=\"gc-howid7c73d4step10\" class=\"gc-howtoitem__step\"><div class=\"gc-howtoitem__title\"><div class=\"gc-howtoitem__heading\">ARRAYFORMULA(): <\/div><\/div><div class=\"gc-howtoitem__content\" ><div class=\"gc-howtoitem__text\">It is used to make a formula work on multiple rows or columns at once, for example =ARRAYFORMULA(A1:A10 * B1:B10) multiplies all values \u200b\u200bin column A by B.<\/div><\/div><\/div><\/div>\n\n\n<h3 class=\"wp-block-heading has-text-align-center has-text-color has-link-color wp-elements-a7bf2db6b823acc22f5ab3646394e0f1\" style=\"color:#e57f7b\"><strong><em>GOOGLETRANSLATE<\/em><\/strong> ISO-639 code<\/h3>\n\n\n<div class=\"gc-box border_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Language<\/th><th>ISO-639 code<\/th><\/tr><\/thead><tbody><tr><td>Abkhaz<\/td><td><code>ab<\/code><\/td><\/tr><tr><td>Acehnese<\/td><td><code>ace<\/code><\/td><\/tr><tr><td>Acholi<\/td><td><code>ach<\/code><\/td><\/tr><tr><td>Afrikaans<\/td><td><code>af<\/code><\/td><\/tr><tr><td>Albanian<\/td><td><code>sq<\/code><\/td><\/tr><tr><td>Alur<\/td><td><code>alz<\/code><\/td><\/tr><tr><td>Amharic<\/td><td><code>am<\/code><\/td><\/tr><tr><td>Arabic<\/td><td><code>ar<\/code><\/td><\/tr><tr><td>Armenian<\/td><td><code>hy<\/code><\/td><\/tr><tr><td>Assamese<\/td><td><code>as<\/code><\/td><\/tr><tr><td>Awadhi<\/td><td><code>awa<\/code><\/td><\/tr><tr><td>Aymara<\/td><td><code>ay<\/code><\/td><\/tr><tr><td>Azerbaijani<\/td><td><code>az<\/code><\/td><\/tr><tr><td>Balinese<\/td><td><code>ban<\/code><\/td><\/tr><tr><td>Bambara<\/td><td><code>bm<\/code><\/td><\/tr><tr><td>Bashkir<\/td><td><code>ba<\/code><\/td><\/tr><tr><td>Basque<\/td><td><code>eu<\/code><\/td><\/tr><tr><td>Batak Karo<\/td><td><code>btx<\/code><\/td><\/tr><tr><td>Batak Simalungun<\/td><td><code>bts<\/code><\/td><\/tr><tr><td>Batak Toba<\/td><td><code>bbc<\/code><\/td><\/tr><tr><td>Belarusian<\/td><td><code>be<\/code><\/td><\/tr><tr><td>Bemba<\/td><td><code>bem<\/code><\/td><\/tr><tr><td>Bengali<\/td><td><code>bn<\/code><\/td><\/tr><tr><td>Betawi<\/td><td><code>bew<\/code><\/td><\/tr><tr><td>Bhojpuri<\/td><td><code>bho<\/code><\/td><\/tr><tr><td>Bikol<\/td><td><code>bik<\/code><\/td><\/tr><tr><td>Bosnian<\/td><td><code>bs<\/code><\/td><\/tr><tr><td>Breton<\/td><td><code>br<\/code><\/td><\/tr><tr><td>Bulgarian<\/td><td><code>bg<\/code><\/td><\/tr><tr><td>Buryat<\/td><td><code>bua<\/code><\/td><\/tr><tr><td>Cantonese<\/td><td><code>yue<\/code><\/td><\/tr><tr><td>Catalan<\/td><td><code>ca<\/code><\/td><\/tr><tr><td>Cebuano<\/td><td><code>ceb<\/code><\/td><\/tr><tr><td>Chichewa (Nyanja)<\/td><td><code>ny<\/code><\/td><\/tr><tr><td>Chinese (Simplified)<\/td><td><code>zh-CN<\/code>&nbsp;or&nbsp;<code>zh<\/code>&nbsp;<\/td><\/tr><tr><td>Chinese (Traditional)<\/td><td><code>zh-TW<\/code>&nbsp;<\/td><\/tr><tr><td>Chuvash<\/td><td><code>cv<\/code><\/td><\/tr><tr><td>Corsican<\/td><td><code>co<\/code><\/td><\/tr><tr><td>Crimean Tatar<\/td><td><code>crh<\/code><\/td><\/tr><tr><td>Croatian<\/td><td><code>hr<\/code><\/td><\/tr><tr><td>Czech<\/td><td><code>cs<\/code><\/td><\/tr><tr><td>Danish<\/td><td><code>da<\/code><\/td><\/tr><tr><td>Dinka<\/td><td><code>din<\/code><\/td><\/tr><tr><td>Divehi<\/td><td><code>dv<\/code><\/td><\/tr><tr><td>Dogri<\/td><td><code>doi<\/code><\/td><\/tr><tr><td>Dombe<\/td><td><code>dov<\/code><\/td><\/tr><tr><td>Dutch<\/td><td><code>nl<\/code><\/td><\/tr><tr><td>Dzongkha<\/td><td><code>dz<\/code><\/td><\/tr><tr><td>English<\/td><td><code>en<\/code><\/td><\/tr><tr><td>Esperanto<\/td><td><code>eo<\/code><\/td><\/tr><tr><td>Estonian<\/td><td><code>et<\/code><\/td><\/tr><tr><td>Ewe<\/td><td><code>ee<\/code><\/td><\/tr><tr><td>Fijian<\/td><td><code>fj<\/code><\/td><\/tr><tr><td>Filipino (Tagalog)<\/td><td><code>fil<\/code>&nbsp;or&nbsp;<code>tl<\/code><\/td><\/tr><tr><td>Finnish<\/td><td><code>fi<\/code><\/td><\/tr><tr><td>French<\/td><td><code>fr<\/code><\/td><\/tr><tr><td>French (French)<\/td><td><code>fr-FR<\/code><\/td><\/tr><tr><td>French (Canadian)<\/td><td><code>fr-CA<\/code><\/td><\/tr><tr><td>Frisian<\/td><td><code>fy<\/code><\/td><\/tr><tr><td>Fulfulde<\/td><td><code>ff<\/code><\/td><\/tr><tr><td>Ga<\/td><td><code>gaa<\/code><\/td><\/tr><tr><td>Galician<\/td><td><code>gl<\/code><\/td><\/tr><tr><td>Ganda (Luganda)<\/td><td><code>lg<\/code><\/td><\/tr><tr><td>Georgian<\/td><td><code>ka<\/code><\/td><\/tr><tr><td>German<\/td><td><code>de<\/code><\/td><\/tr><tr><td>Greek<\/td><td><code>el<\/code><\/td><\/tr><tr><td>Guarani<\/td><td><code>gn<\/code><\/td><\/tr><tr><td>Gujarati<\/td><td><code>gu<\/code><\/td><\/tr><tr><td>Haitian Creole<\/td><td><code>ht<\/code><\/td><\/tr><tr><td>Hakha Chin<\/td><td><code>cnh<\/code><\/td><\/tr><tr><td>Hausa<\/td><td><code>ha<\/code><\/td><\/tr><tr><td>Hawaiian<\/td><td><code>haw<\/code><\/td><\/tr><tr><td>Hebrew<\/td><td><code>iw<\/code>&nbsp;or&nbsp;<code>he<\/code><\/td><\/tr><tr><td>Hiligaynon<\/td><td><code>hil<\/code><\/td><\/tr><tr><td>Hindi<\/td><td><code>hi<\/code><\/td><\/tr><tr><td>Hmong<\/td><td><code>hmn<\/code><\/td><\/tr><tr><td>Hungarian<\/td><td><code>hu<\/code><\/td><\/tr><tr><td>Hunsrik<\/td><td><code>hrx<\/code><\/td><\/tr><tr><td>Icelandic<\/td><td><code>is<\/code><\/td><\/tr><tr><td>Igbo<\/td><td><code>ig<\/code><\/td><\/tr><tr><td>Iloko<\/td><td><code>ilo<\/code><\/td><\/tr><tr><td>Indonesian<\/td><td><code>id<\/code><\/td><\/tr><tr><td>Irish<\/td><td><code>ga<\/code><\/td><\/tr><tr><td>Italian<\/td><td><code>it<\/code><\/td><\/tr><tr><td>Japanese<\/td><td><code>ja<\/code><\/td><\/tr><tr><td>Javanese<\/td><td><code>jw<\/code>&nbsp;or&nbsp;<code>jv<\/code><\/td><\/tr><tr><td>Kannada<\/td><td><code>kn<\/code><\/td><\/tr><tr><td>Kapampangan<\/td><td><code>pam<\/code><\/td><\/tr><tr><td>Kazakh<\/td><td><code>kk<\/code><\/td><\/tr><tr><td>Khmer<\/td><td><code>km<\/code><\/td><\/tr><tr><td>Kiga<\/td><td><code>cgg<\/code><\/td><\/tr><tr><td>Kinyarwanda<\/td><td><code>rw<\/code><\/td><\/tr><tr><td>Kituba<\/td><td><code>ktu<\/code><\/td><\/tr><tr><td>Konkani<\/td><td><code>gom<\/code><\/td><\/tr><tr><td>Korean<\/td><td><code>ko<\/code><\/td><\/tr><tr><td>Krio<\/td><td><code>kri<\/code><\/td><\/tr><tr><td>Kurdish (Kurmanji)<\/td><td><code>ku<\/code><\/td><\/tr><tr><td>Kurdish (Sorani)<\/td><td><code>ckb<\/code><\/td><\/tr><tr><td>Kyrgyz<\/td><td><code>ky<\/code><\/td><\/tr><tr><td>Lao<\/td><td><code>lo<\/code><\/td><\/tr><tr><td>Latgalian<\/td><td><code>ltg<\/code><\/td><\/tr><tr><td>Latin<\/td><td><code>la<\/code><\/td><\/tr><tr><td>Latvian<\/td><td><code>lv<\/code><\/td><\/tr><tr><td>Ligurian<\/td><td><code>lij<\/code><\/td><\/tr><tr><td>Limburgan<\/td><td><code>li<\/code><\/td><\/tr><tr><td>Lingala<\/td><td><code>ln<\/code><\/td><\/tr><tr><td>Lithuanian<\/td><td><code>lt<\/code><\/td><\/tr><tr><td>Lombard<\/td><td><code>lmo<\/code><\/td><\/tr><tr><td>Luo<\/td><td><code>luo<\/code><\/td><\/tr><tr><td>Luxembourgish<\/td><td><code>lb<\/code><\/td><\/tr><tr><td>Macedonian<\/td><td><code>mk<\/code><\/td><\/tr><tr><td>Maithili<\/td><td><code>mai<\/code><\/td><\/tr><tr><td>Makassar<\/td><td><code>mak<\/code><\/td><\/tr><tr><td>Malagasy<\/td><td><code>mg<\/code><\/td><\/tr><tr><td>Malay<\/td><td><code>ms<\/code><\/td><\/tr><tr><td>Malay (Jawi)<\/td><td><code>ms-Arab<\/code><\/td><\/tr><tr><td>Malayalam<\/td><td><code>ml<\/code><\/td><\/tr><tr><td>Maltese<\/td><td><code>mt<\/code><\/td><\/tr><tr><td>Maori<\/td><td><code>mi<\/code><\/td><\/tr><tr><td>Marathi<\/td><td><code>mr<\/code><\/td><\/tr><tr><td>Meadow Mari<\/td><td><code>chm<\/code><\/td><\/tr><tr><td>Meiteilon (Manipuri)<\/td><td><code>mni-Mtei<\/code><\/td><\/tr><tr><td>Minang<\/td><td><code>min<\/code><\/td><\/tr><tr><td>Mizo<\/td><td><code>lus<\/code><\/td><\/tr><tr><td>Mongolian<\/td><td><code>mn<\/code><\/td><\/tr><tr><td>Myanmar (Burmese)<\/td><td><code>my<\/code><\/td><\/tr><tr><td>Ndebele (South)<\/td><td><code>nr<\/code><\/td><\/tr><tr><td>Nepalbhasa (Newari)<\/td><td><code>new<\/code><\/td><\/tr><tr><td>Nepali<\/td><td><code>ne<\/code><\/td><\/tr><tr><td>Northern Sotho (Sepedi)<\/td><td><code>nso<\/code><\/td><\/tr><tr><td>Norwegian<\/td><td><code>no<\/code><\/td><\/tr><tr><td>Nuer<\/td><td><code>nus<\/code><\/td><\/tr><tr><td>Occitan<\/td><td><code>oc<\/code><\/td><\/tr><tr><td>Odia (Oriya)<\/td><td><code>or<\/code><\/td><\/tr><tr><td>Oromo<\/td><td><code>om<\/code><\/td><\/tr><tr><td>Pangasinan<\/td><td><code>pag<\/code><\/td><\/tr><tr><td>Papiamento<\/td><td><code>pap<\/code><\/td><\/tr><tr><td>Pashto<\/td><td><code>ps<\/code><\/td><\/tr><tr><td>Persian<\/td><td><code>fa<\/code><\/td><\/tr><tr><td>Polish<\/td><td><code>pl<\/code><\/td><\/tr><tr><td>Portuguese<\/td><td><code>pt<\/code><\/td><\/tr><tr><td>Portuguese (Portugal)<\/td><td><code>pt-PT<\/code><\/td><\/tr><tr><td>Portuguese (Brazil)<\/td><td><code>pt-BR<\/code><\/td><\/tr><tr><td>Punjabi<\/td><td><code>pa<\/code><\/td><\/tr><tr><td>Punjabi (Shahmukhi)<\/td><td><code>pa-Arab<\/code><\/td><\/tr><tr><td>Quechua<\/td><td><code>qu<\/code><\/td><\/tr><tr><td>Romani<\/td><td><code>rom<\/code><\/td><\/tr><tr><td>Romanian<\/td><td><code>ro<\/code><\/td><\/tr><tr><td>Rundi<\/td><td><code>rn<\/code><\/td><\/tr><tr><td>Russian<\/td><td><code>ru<\/code><\/td><\/tr><tr><td>Samoan<\/td><td><code>sm<\/code><\/td><\/tr><tr><td>Sango<\/td><td><code>sg<\/code><\/td><\/tr><tr><td>Sanskrit<\/td><td><code>sa<\/code><\/td><\/tr><tr><td>Scots Gaelic<\/td><td><code>gd<\/code><\/td><\/tr><tr><td>Serbian<\/td><td><code>sr<\/code><\/td><\/tr><tr><td>Sesotho<\/td><td><code>st<\/code><\/td><\/tr><tr><td>Seychellois Creole<\/td><td><code>crs<\/code><\/td><\/tr><tr><td>Shan<\/td><td><code>shn<\/code><\/td><\/tr><tr><td>Shona<\/td><td><code>sn<\/code><\/td><\/tr><tr><td>Sicilian<\/td><td><code>scn<\/code><\/td><\/tr><tr><td>Silesian<\/td><td><code>szl<\/code><\/td><\/tr><tr><td>Sindhi<\/td><td><code>sd<\/code><\/td><\/tr><tr><td>Sinhala (Sinhalese)<\/td><td><code>si<\/code><\/td><\/tr><tr><td>Slovak<\/td><td><code>sk<\/code><\/td><\/tr><tr><td>Slovenian<\/td><td><code>sl<\/code><\/td><\/tr><tr><td>Somali<\/td><td><code>so<\/code><\/td><\/tr><tr><td>Spanish<\/td><td><code>es<\/code><\/td><\/tr><tr><td>Sundanese<\/td><td><code>su<\/code><\/td><\/tr><tr><td>Swahili<\/td><td><code>sw<\/code><\/td><\/tr><tr><td>Swati<\/td><td><code>ss<\/code><\/td><\/tr><tr><td>Swedish<\/td><td><code>sv<\/code><\/td><\/tr><tr><td>Tajik<\/td><td><code>tg<\/code><\/td><\/tr><tr><td>Tamil<\/td><td><code>ta<\/code><\/td><\/tr><tr><td>Tatar<\/td><td><code>tt<\/code><\/td><\/tr><tr><td>Telugu<\/td><td><code>te<\/code><\/td><\/tr><tr><td>Tetum<\/td><td><code>tet<\/code><\/td><\/tr><tr><td>Thai<\/td><td><code>th<\/code><\/td><\/tr><tr><td>Tigrinya<\/td><td><code>ti<\/code><\/td><\/tr><tr><td>Tsonga<\/td><td><code>ts<\/code><\/td><\/tr><tr><td>Tswana<\/td><td><code>tn<\/code><\/td><\/tr><tr><td>Turkish<\/td><td><code>tr<\/code><\/td><\/tr><tr><td>Turkmen<\/td><td><code>tk<\/code><\/td><\/tr><tr><td>Twi (Akan)<\/td><td><code>ak<\/code><\/td><\/tr><tr><td>Ukrainian<\/td><td><code>uk<\/code><\/td><\/tr><tr><td>Urdu<\/td><td><code>ur<\/code><\/td><\/tr><tr><td>Uyghur<\/td><td><code>ug<\/code><\/td><\/tr><tr><td>Uzbek<\/td><td><code>uz<\/code><\/td><\/tr><tr><td>Vietnamese<\/td><td><code>vi<\/code><\/td><\/tr><tr><td>Welsh<\/td><td><code>cy<\/code><\/td><\/tr><tr><td>Xhosa<\/td><td><code>xh<\/code><\/td><\/tr><tr><td>Yiddish<\/td><td><code>yi<\/code><\/td><\/tr><tr><td>Yoruba<\/td><td><code>yo<\/code><\/td><\/tr><tr><td>Yucatec Maya<\/td><td><code>yua<\/code><\/td><\/tr><tr><td>Zulu<\/td><td><code>zu<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n<\/div>\n\t\t<\/div>\n\n<div class=\"gc-box blue_type\" style=\"text-align:left;border-radius:20px;box-shadow: 0 10px 10px #00000007\">\n\t\t\t<div class=\"gc-box-icon\"><\/div>\n\t\t\t\n\t\t\t<div class=\"gc-box-text\">\n\n<p>These functions can help you work with data in Google Sheets faster and more efficiently. Try them out in your projects and you may discover new ways to make your work easier!<\/p>\n\n<\/div>\n\t\t<\/div>","protected":false},"excerpt":{"rendered":"Google Sheet is a tool with many functions that help you manage your data efficiently. Today we will introduce you to some secret or lesser-known but very useful functions in Google Sheet.","protected":false},"author":1,"featured_media":2274,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_singular_sidebar":"","csco_page_header_type":"","csco_page_load_nextpost":"","footnotes":""},"categories":[32],"tags":[],"class_list":{"0":"post-2184","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-google-sheet","8":"cs-entry"},"_links":{"self":[{"href":"https:\/\/siammakemoney.com\/en\/wp-json\/wp\/v2\/posts\/2184","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/siammakemoney.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/siammakemoney.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/siammakemoney.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/siammakemoney.com\/en\/wp-json\/wp\/v2\/comments?post=2184"}],"version-history":[{"count":61,"href":"https:\/\/siammakemoney.com\/en\/wp-json\/wp\/v2\/posts\/2184\/revisions"}],"predecessor-version":[{"id":6951,"href":"https:\/\/siammakemoney.com\/en\/wp-json\/wp\/v2\/posts\/2184\/revisions\/6951"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/siammakemoney.com\/en\/wp-json\/wp\/v2\/media\/2274"}],"wp:attachment":[{"href":"https:\/\/siammakemoney.com\/en\/wp-json\/wp\/v2\/media?parent=2184"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/siammakemoney.com\/en\/wp-json\/wp\/v2\/categories?post=2184"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/siammakemoney.com\/en\/wp-json\/wp\/v2\/tags?post=2184"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}