---
title: "CHAR Function in Google Sheets: List of Codes and Examples"
canonical: "https://www.owox.com/blog/articles/char-function-google-sheets"
updated: "2026-10-05"
---

# CHAR function in Google Sheets: list of codes and examples

CHAR converts a Unicode number into its character: CHAR(10003) is a check mark, CHAR(10) a line break. This guide gives a list of the codes used most often in spreadsheets, a formula that builds your own list, and examples: line breaks in a cell, arrows for trends, star ratings, and cleaning imported text.

[Google Sheets Tips](/blog/topics/google-sheets-tips) · Updated October 2, 2026 · [Vadym Kramarenko](/team/vadym-kramarenko) · 11 min read

![CHAR function in Google Sheets: list of codes and examples](https://cdn.owox.com/www/content-marketing-article/char-function-google-sheets/thumbnail/1-eesf57.png/public)

The CHAR function returns the character that belongs to a number in the Unicode table:

> `=CHAR(10003)`

The formula returns ✓. CHAR(65) is the letter A, CHAR(10) a line break, CHAR(9733) a star. The function takes any whole number from 1 to 1,114,111, so it reaches far beyond the 255 codes of the old ASCII tables: arrows, check marks, currency signs and emoji are all available.

## List of CHAR codes

The codes used most often in spreadsheets. Every result can be copied from the table or produced with the formula next to it.

### Line breaks, spaces and punctuation

| Formula | Result | Name |
| --- | --- | --- |
| `CHAR(10)` | (line break) | Line break inside a cell |
| `CHAR(9)` | (tab) | Tab |
| `CHAR(32)` | (space) | Space |
| `CHAR(160)` | (space) | Non-breaking space, common in text copied from web pages |
| `CHAR(34)` | `"` | Double quote, for use inside a formula |
| `CHAR(8226)` | • | Bullet |
| `CHAR(8211)` | – | En dash |
| `CHAR(8230)` | … | Ellipsis |

### Check marks and status signs

| Formula | Result | Name |
| --- | --- | --- |
| `CHAR(10003)` | ✓ | Check mark |
| `CHAR(10004)` | ✔ | Heavy check mark |
| `CHAR(10007)` | ✗ | Cross |
| `CHAR(10060)` | ❌ | Red cross |
| `CHAR(9989)` | ✅ | Green check |
| `CHAR(9745)` | ☑ | Checked box |
| `CHAR(9744)` | ☐ | Empty box |
| `CHAR(9888)` | ⚠ | Warning sign |
| `CHAR(128308)` | 🔴 | Red circle |
| `CHAR(128994)` | 🟢 | Green circle |

### Arrows, stars and shapes

| Formula | Result | Name |
| --- | --- | --- |
| `CHAR(8593)` | ↑ | Arrow up |
| `CHAR(8595)` | ↓ | Arrow down |
| `CHAR(8594)` | → | Arrow right |
| `CHAR(8592)` | ← | Arrow left |
| `CHAR(8596)` | ↔ | Arrow left and right |
| `CHAR(9650)` | ▲ | Triangle up |
| `CHAR(9660)` | ▼ | Triangle down |
| `CHAR(9733)` | ★ | Filled star |
| `CHAR(9734)` | ☆ | Empty star |
| `CHAR(9679)` | ● | Filled circle |
| `CHAR(9675)` | ○ | Empty circle |
| `CHAR(9632)` | ■ | Filled square |
| `CHAR(9608)` | █ | Full block, for bars |

### Math and greek letters

| Formula | Result | Name |
| --- | --- | --- |
| `CHAR(176)` | ° | Degree |
| `CHAR(177)` | ± | Plus-minus |
| `CHAR(215)` | × | Multiplication |
| `CHAR(247)` | ÷ | Division |
| `CHAR(8800)` | ≠ | Not equal |
| `CHAR(8776)` | ≈ | Approximately equal |
| `CHAR(8804)` | ≤ | Less than or equal |
| `CHAR(8805)` | ≥ | Greater than or equal |
| `CHAR(8734)` | ∞ | Infinity |
| `CHAR(8730)` | √ | Square root |
| `CHAR(931)` | Σ | Sigma |
| `CHAR(916)` | Δ | Delta |
| `CHAR(960)` | π | Pi |
| `CHAR(189)` | ½ | One half |
| `CHAR(8240)` | ‰ | Per mille |

### Currency, legal signs, superscripts and emoji

| Formula | Result | Name |
| --- | --- | --- |
| `CHAR(8364)` | € | Euro |
| `CHAR(163)` | £ | Pound |
| `CHAR(165)` | ¥ | Yen |
| `CHAR(162)` | ¢ | Cent |
| `CHAR(8383)` | ₿ | Bitcoin |
| `CHAR(169)` | © | Copyright |
| `CHAR(174)` | ® | Registered |
| `CHAR(8482)` | ™ | Trademark |
| `CHAR(185)` | ¹ | Superscript 1 |
| `CHAR(178)` | ² | Superscript 2 |
| `CHAR(179)` | ³ | Superscript 3 |
| `CHAR(8320)` | ₀ | Subscript 0; the digits up to 9 follow, to 8329 |
| `CHAR(128512)` | 😀 | Grinning face |
| `CHAR(128077)` | 👍 | Thumbs up |

Letters and digits follow the ASCII order: 48 to 57 are the digits 0 to 9, 65 to 90 the capital letters A to Z, 97 to 122 the small letters a to z.

### Build your own list

To browse a part of the Unicode table, generate the numbers with SEQUENCE and pass them to CHAR:

> `=ARRAYFORMULA({SEQUENCE(8,1,9728), CHAR(SEQUENCE(8,1,9728))})`

![Google Sheets with the formula =ARRAYFORMULA({SEQUENCE(8,1,9728), CHAR(SEQUENCE(8,1,9728))}) returning the codes 9728 to 9735 in column B and their characters, among them a sun, a cloud and two stars, in column C](https://cdn.owox.com/www/content-marketing-article/char-function-google-sheets/screens/2.png/public)

The first number is how many rows to list, the last one the code to start from. Change 8 to 100 and 9728 to 8592 to see a hundred arrows.

### Find the code of a character

The reverse function is UNICODE:

> `=UNICODE("€")`

It returns 8364. Paste any character between the quotes, or point the formula to a cell: for a longer text it returns the code of the first character. CODE does the same job.

## CHAR syntax

> `=CHAR(table_number)`

*   **table\_number:** the number of the character in the Unicode table, typed in or taken from a cell.

A decimal is cut to a whole number: CHAR(65.9) returns A. Whether a character is displayed depends on the font and the device; a code with no glyph shows as an empty box.

![Google Sheets with codes 128512 to 128516 in column C and the formula =CHAR(128512) returning emoji faces in column E](https://cdn.owox.com/www/webflow/67a0c28db0d871b8161c8ca8_AD_4nXeJnNaSho6lT5IXev3CPQsFIyajtI87JTbiQnbiDRjAIlMwOs6mp1_mz2iCpfcQaCOz3tfKAOf3Vhfv3t15pmSum4GhaGC0kWoAGlFVB31aLL5IfYA_WKD7RuZZ9yMjNdVzGWEy.png/public)

The code can sit in a cell, so one formula covers a whole column:

> `=CHAR(C3)`

![Google Sheets with the codes 8593 and 8595 in column C and the formula =CHAR(C3) returning up and down arrows](https://cdn.owox.com/www/webflow/67a0c28da0e25d2c9659177d_AD_4nXcrXru8JDSwMPpy3TA1DfoPtRupTOlil48adU_brSwEQ4arPJhZIopR84HZdrOOzw8o27ZiPTGDZ3V-pzueZokjdomvUgXXAW9QL43sHYxHD6PEDHrFG2w11QrK82RKRMjFdjYZTg.png/public)

![Google Sheets with the codes 36, 8364, 163, 165 and 3647 in column D and the formula =CHAR(D3) returning currency symbols](https://cdn.owox.com/www/webflow/67a0c28d8f35b36230e631de_AD_4nXcRRB4RdNJY8xa53KsZajZEzRgl2MYJewkbFoztFtp_wEzHK349EzWOZoOcXlkqZHCYn1Ku_xTRxj6tct-diHpgAHYnx6vCaWhQ9mLMX1I5WkKK7ejpMdRCFexViQRrbfz-CcGB.png/public)

![Google Sheets with the formula =CHAR(931) returning the Greek letter sigma](https://cdn.owox.com/www/webflow/67a0c28d1b233de538c89e7d_AD_4nXfU49FCWFmvFrNB5VX973XprTviRrwu3ebDe-FA-W6WKfoVrYuAIr-kXxC6Entsz3v2d4nVxwTihpalClmhxh1ZIXneiqKG4jx2NidGPHR1Y_dJeN2fsJ7nouI5K6WZwSQ1HewI.png/public)

## The Turning Point

OWOX Data Marts

See your first report built in real time. _15 minutes._

1.  Connect your data warehouse
2.  Pick your metrics
3.  Get a live Google Sheets report

In the time it takes to write a ticket. Then imagine never writing that ticket again.

[Book a Demo](/book-a-call)

We'll use your actual use case

## Line breaks with CHAR(10)

CHAR(10) starts a new line inside the cell. It is the only way to do so from a formula:

> `="James builds strong client loyalty" & CHAR(10) & "by always exceeding expectations."`

![Google Sheets with a formula that joins two texts with CHAR(10), shown on two lines in one cell](https://cdn.owox.com/www/webflow/67a0c28d0a5bd4d0aed04400_AD_4nXeGB1nc61ogDFa4zCUBlc9L6I8BWKRUbC9EPa6XUaLDUNDFsjbW1wbtCtWrqs4al66J7nW_D0Ne4BJXEw2qLh20Cdm1eqH5H0Su7-TjCPBk3E-KvptHasIiCfUpfMgjeSf2COfybw.png/public)

The same character works as a separator in JOIN and TEXTJOIN, which turns a column into a list inside one cell:

> `=JOIN(CHAR(10), B3:B7)`

![Google Sheets with the formula =JOIN(CHAR(10), B3:B7) returning five employee names on five lines in one cell](https://cdn.owox.com/www/webflow/67a0c28d0a5bd4d0aed043fd_AD_4nXeTb7V-PilYdlPALuZ6BgJU5iGNmP_s3hrBE7qNxatQbHKoTkZjzGQfc3LJJhcTNvY4SxXZbWRKMDQhVoFP1CsdBZZe-pIKzgJEKT93uhdScbXAswdm4vQkIy42peoAU7ooBamcQQ.png/public)

And in the other direction, to remove or use line breaks that came with the data:

*   `=SUBSTITUTE(A2, CHAR(10), " ")` replaces every line break with a space.
*   `=SPLIT(A2, CHAR(10))` puts each line into its own cell.

More on both in the guides to [JOIN and TEXTJOIN](/blog/articles/join-textjoin-functions-google-sheets) and [SUBSTITUTE](/blog/articles/substitute-function-google-sheets). Long lines inside the cell follow the cell’s [text wrapping](/blog/articles/how-to-wrap-text-google-sheets) setting.

### A header with two labels

> `="Performance % (month) " & CHAR(8594) & CHAR(10) & "Career Stage " & CHAR(8595)`

![Google Sheets with a header cell on two lines: Performance % (month) with an arrow right and Career Stage with an arrow down](https://cdn.owox.com/www/webflow/67a0c28d84eca7c224b6d7ef_AD_4nXcP-w4D_DgDJGK_xPQ61Z0OLcPqwrXffEUmFKUWaXBSBIMN-W09SQd3vSj0H_aDBG6cdRFiV8topHr42FjZhtq9jpl9VSsmM9n89shOhd9dotUxdOPf6TkQCG5gvSvwL7dk6vj7TA.png/public)

One cell names both the columns to its right and the rows below it.

## Symbols next to a value

Join CHAR to text or to a cell with an ampersand:

> `=B3 & CHAR(C3)`

![Google Sheets with employee names in column B, emoji codes in column C and a formula returning each name followed by its emoji](https://cdn.owox.com/www/webflow/67a0c28dfe70d5ccc0d0e653_AD_4nXcPJ7ggRnIjkkDhKGxpIYbeRFr7iMKtBdjpbKW1AcxaZOVO3sJdl89fJhaeYNN-f5Z6Hv-4Yju0US6v2lTtXx-V7aMAcOB0wr5eKWdgHLsZ-sWFye_Wdva-MxnoZd_Jt-_dG8Dc.png/public)

> `=CHAR(C3) & " " & CHAR(D3)`

![Google Sheets with arrow codes in column C and star codes in column D and the formula =CHAR(C3) & “ “ & CHAR(D3) returning an arrow and a star in one cell](https://cdn.owox.com/www/webflow/67a0c28d7e602315731f3829_AD_4nXfG351bqUGA2moAHGOXzDORCcaW3g19bhh3Va_5_PjNRPye8UJPF9CqPojYeZb6sLsJo0KCxOK3q58biCFPFsbNs3T1KKyRWHXH7RTYEpilZZdYblQncMbW-4a_KE6l5Ge9mOoLNA.png/public)

### Trend arrows

Let IF choose the symbol, so that it changes with the data:

> `=IF(C3 > B3, CHAR(9650), IF(C3 < B3, CHAR(9660), CHAR(8211)))`

A triangle up for growth, a triangle down for decline, a dash for no change. Add color with conditional formatting on the same condition.

### Superscripts and subscripts

Unicode has ready-made small digits. Superscript 1, 2 and 3 are the codes 185, 178 and 179; subscript digits run from 8320 to 8329.

> `="Shift" & CHAR(185)`

![Google Sheets with the codes 185, 178 and 179 in column C and the formula =“Shift” & CHAR(185) returning Shift with a superscript digit](https://cdn.owox.com/www/webflow/67a0c28d4c24b8337e11dc5d_AD_4nXdQfupNHsDUVYbhq8dByOLa5cdMwRtkSSOlLb1R3q1sZC4bjafM1TOKebLM9XpYSN61c3ZTjt9tRgtbz79HbfGUviLk1wXRmeTfLi19KacMPb2M0kcxfxYl7fQK-lJF_JsinCsnRg.png/public)

> `="Level" & CHAR(8324)`

![Google Sheets with the codes 8321 to 8324 in column C and the formula =“Level” & CHAR(8324) returning Level with a subscript digit](https://cdn.owox.com/www/webflow/67a0c28d8366382c6268cab0_AD_4nXcMnhwZ4Ol_0169Og5BYkdH3nu_SQzkhZO78nBGIwBEi0k98Zq8u5XUkbacpdeu3tEm0ofU6TkcRoeojcn_ARRQcyU4Vn2Oreq1EVr9VVa3D_VaP32Xa-Uchj_jo2adhqJEmAQ51A.png/public)

### Quotes inside a formula

A double quote ends a text in a formula, so a quote that belongs to the text is written as CHAR(34):

> `="The status is " & CHAR(34) & B2 & CHAR(34)`

## CHAR with other functions

### REPT: star ratings and bars

[REPT](/blog/articles/rept-function-google-sheets) repeats a character a given number of times:

> `=REPT(CHAR(9733), C3)`

![Google Sheets with scores from 3 to 5 in column C and the formula =REPT(CHAR(9733), C3) returning the same number of stars](https://cdn.owox.com/www/webflow/67a0c28dd359b147cbecdbea_AD_4nXf0nYutZdOdvxXTT65mLA6WLe9Uffg8I8HWUaGqkINdFybHviNt_U4bEErJ73m0JyyaoFhLxX7wHLs1C8ajzMRw93fjYVDybk1bWWAECeLC1v23OK1mTaVVaX8AIXdBEUbKVQ2d1Q.png/public)

For a fixed scale, fill the rest with empty stars:

> `=REPT(CHAR(9733), C3) & REPT(CHAR(9734), 5 - C3)`

The full block makes a bar inside a cell: `=REPT(CHAR(9608), B2/10)` draws seven blocks for 70. For real charts in a cell, see [SPARKLINE](/blog/articles/sparkline-google-sheets).

### SEQUENCE: a run of characters

> `=ARRAYFORMULA(B3:B7 & " " & CHAR(128512 + SEQUENCE(COUNTA(B3:B7), 1, 0, 1)) & " - " & C3:C7)`

![Google Sheets with a formula that joins each employee name, an emoji whose code grows by one per row, and a description](https://cdn.owox.com/www/webflow/67a0c28d875383aa5d967afe_AD_4nXfLBjQc3XACqycvmgdeMQ7gvdpU593yC3edeymOtCkgOY60yhoeF9nDAYV-POciNLY6nCAsuCNAKER0O2iIPCfNiYldkPCo6RqzDs-0d-Cxp4HI4gGvQIppIjbpDpEP-T3H5qOe1A.png/public)

SEQUENCE returns 0, 1, 2 and so on, one number for each name; added to 128512 it gives a different emoji per row. The same idea returns the alphabet: `=ARRAYFORMULA(CHAR(SEQUENCE(26, 1, 65)))`.

### QUERY: filter by a symbol

A symbol can be a filter value. Building it with CHAR avoids pasting it into the query text:

> `=QUERY(B2:C7, "SELECT B, C WHERE C = '" & CHAR(10003) & "'", 1)`

![Google Sheets with a renewal status column of check marks and crosses and a QUERY formula returning only the rows with a check mark](https://cdn.owox.com/www/webflow/67a0c28da0e25d2c9659177a_AD_4nXf418k_z4Wnbm2Xu1eVnifmf-WPWwhbPUD7_HIgRxOPCg167-UTZDEFgB0WmfNZP-tZj3D3B8-85lq7nAv-Zy2FtL-Mj3oixMo-1QX42jHPI8gie8ab9qQFLbYxYeGjn0o5mZ5q.png/public)

The same works in [COUNTIF](/blog/articles/countif-and-countifs-google-sheets): `=COUNTIF(C3:C7, CHAR(10003))` counts the check marks.

### SUBSTITUTE: clean imported text

Text copied from web pages often holds non-breaking spaces, CHAR(160), which look like spaces but are not removed by [TRIM](/blog/articles/trim-clean-t-functions-google-sheets) and break lookups. Replace them first:

> `=TRIM(SUBSTITUTE(A2, CHAR(160), " "))`

## Errors with CHAR

**⚠️ Error:** #NUM!

✅ **Solution:** The number is outside the table: 0, a negative number, or more than 1,114,111. An empty cell counts as 0, so `=CHAR(C3)` on an empty C3 returns #NUM! as well. Wrap it: `=IF(C3="", "", CHAR(C3))`.

**⚠️ Error:** #VALUE!

✅ **Solution:** The argument is text. CHAR(“A”) does not work; to go from a character to its number use UNICODE(“A”).

**⚠️ Error:** An empty box or a question mark appears.

✅ **Solution:** The code is valid, but the font has no glyph for it. Try a neighbouring code or another font, and check the result on the devices your readers use: emoji look different on each system.

**⚠️ Error:** LEN returns 2 for one emoji.

✅ **Solution:** Characters above code 65,535, which includes most emoji, are stored as two units, and [LEN](/blog/articles/len-function-google-sheets) counts both. Keep this in mind when cutting text with LEFT or MID.

**⚠️ Error:** The line break from CHAR(10) is lost in an export.

✅ **Solution:** A line break inside a cell is kept in the sheet, but a CSV export wraps such a cell in quotes, and some tools read it as a new row. Replace the line breaks before exporting.

## Related Google Sheets functions

*   [REPT](/blog/articles/rept-function-google-sheets): Repeat a character or a text.
*   [CONCATENATE and the ampersand](/blog/articles/concatenate-and-ampersand-google-sheets): Join text and symbols.
*   [JOIN and TEXTJOIN](/blog/articles/join-textjoin-functions-google-sheets): Join a range with a separator such as CHAR(10).
*   [SUBSTITUTE](/blog/articles/substitute-function-google-sheets): Replace one character with another.
*   [TRIM, CLEAN and T](/blog/articles/trim-clean-t-functions-google-sheets): Remove spaces and non-printing characters.
*   [TEXT](/blog/articles/text-function-google-sheets): Format numbers and dates as text.
*   [How to wrap text](/blog/articles/how-to-wrap-text-google-sheets): Show long text and line breaks in a cell.
*   [SPARKLINE](/blog/articles/sparkline-google-sheets): A small chart inside a cell.

## A symbol is a label for a number that has to be right

A green check or a triangle pointing up is read faster than any number, which is exactly why it has to rest on current data. The arrow from the IF formula above compares two cells; if those cells were pasted from an export a month ago, the report shows last month with full confidence.

The [OWOX Data Marts extension for Google Sheets](https://workspace.google.com/marketplace/app/owox_data_marts/94902851409) covers that half. A data analyst publishes a data mart (a table or an SQL query in your data warehouse) and makes it available for reports. In Sheets you open the extension, pick the data mart, tick the columns you want and run it. The rows land in a tab, ready for your formulas.

![Google Sheets with the OWOX Data Marts extension open beside an ad spend table: the Unified Ad Spend data mart, nine of fourteen columns ticked and a Save & Run button – the rows in the sheet come from a governed data mart, not a pasted export](https://cdn.owox.com/www/content-marketing-article/char-function-google-sheets/screens/1.png/public)

What changes for the person who maintains the sheet:

*   **Refresh replaces re-export.** _Refresh current report_ in the extension menu re-runs the same pull, and a scheduled refresh keeps the tab current without anyone touching it.
*   **The source is written on the sheet.** The header cell of an imported tab carries a note with the data mart it came from, the time of the import and a link to the report.
*   **No SQL and no warehouse access needed.** The analyst decides which data marts and columns are available. You choose from that list.

The extension does not write or change the analyst’s SQL. The symbols your formulas draw then follow the refreshed numbers, not the last manual paste. The extension comes with the OWOX Cloud plans of [OWOX Data Marts](https://www.owox.com/app-signup); [spreadsheet reporting](/features/spreadsheet-reporting) describes both ways data reaches a sheet.

## Your New Normal

Turn your data into decisions.

Governed data marts give you the clean foundation ML needs to actually work.

*   No AI hallucinations
*   Analyst-governed definitions
*   Every number traces to SQL

[Get started free](https://www.owox.com/app-signup)

## FAQ

## Frequently Asked Questions

What are some common use cases for the CHAR function in Google Sheets?

Common use cases for the CHAR function in Google Sheets include inserting special symbols, emojis, or non-printable characters like line breaks **(CHAR(10))**, adding visual indicators for data trends, converting Unicode values into readable characters, and enhancing text formatting for better data presentation and organization.

Can I combine the CHAR function with other text functions?

Yes, you can combine the CHAR function with other text functions like CONCATENATE, LEFT, RIGHT, MID, or ARRAYFORMULA in Google Sheets. This allows you to create dynamic text strings, format data, or insert special characters seamlessly within more complex formulas for efficient text manipulation.

Is the CHAR function compatible with all operating systems and devices?

The function works the same everywhere Google Sheets runs, and the same code always returns the same character. How the character looks depends on the font and the device: emoji are drawn differently on each system, and a character the font does not have shows as an empty box. Check symbols on the devices your readers use.

How do I find the Unicode value for a specific character?

To find the Unicode value for a specific character, you can use the UNICODE function in Google Sheets. Simply enter the character within the function, like **\=UNICODE("A")**, and it will return the Unicode value for that character.

Can the CHAR function generate special symbols or emojis?

Yes. CHAR takes any Unicode number from 1 to 1,114,111, so it returns symbols and emoji as well as letters: CHAR(10003) is a check mark, CHAR(9733) a star, CHAR(128512) a grinning face. To find the number of a character you already have, use UNICODE, for example UNICODE("€") returns 8364.

How do I use the CHAR function to insert line breaks in Google Sheets?

To insert line breaks using the CHAR function in Google Sheets, use the formula **\="Text1" & CHAR(10) & "Text2". Replace "Text1" and "Text2"** with your text. **CHAR(10)** is the line feed character that creates the line break between the two segments of text.

How do I create a star rating system in Google Sheets?

To create a star rating system, you can use the REPT function combined with the CHAR function. For example, **\=REPT(CHAR(9733), A1)** will display filled stars based on the value in cell A1. For half stars, you can adjust the formula to include a different character for half ratings.

What is the CHAR function used for in Google Sheets?

The CHAR function in Google Sheets converts a numeric Unicode code into the corresponding character. Its syntax is **\=CHAR(number)**, where number is the Unicode value. This function is useful for inserting special characters, symbols, or emojis into your text based on their Unicode representation.

## Who wrote this

![Vadym Kramarenko](https://cdn.owox.com/www/webflow/6798e703afdf787334941cde_Vadym-Kramarenko.png/public)

[Vadym Kramarenko](/team/vadym-kramarenko) Growth Marketing Manager

Vadym Kramarenko is a Growth Marketing Manager at OWOX, where he drives user acquisition and product-led growth strategies. He hosts the OWOX podcast, interviewing analytics professionals about data-driven marketing, attribution, and reporting best practices. Vadym specializes in turning complex analytics concepts into practical, actionable marketing frameworks.

[LinkedIn](https://www.linkedin.com/in/vadim-kramarenko/) · [All articles](/team/vadym-kramarenko)

[Google Sheets Tips](/blog/topics/google-sheets-tips)

## Related articles

[Google Sheets Tips · Pivot Tables in Google Sheets: How to Create and Use Them · October 2, 2026](/blog/articles/pivot-tables-google-sheets)

[Google Sheets Tips · QUERY with CONCATENATE in Google Sheets: Join Two Columns · October 2, 2026](/blog/articles/query-with-concatenate-google-sheets)

[Google Sheets Tips · QUERY with IMPORTRANGE in Google Sheets: Formula, Examples · October 2, 2026](/blog/articles/query-with-importrange-google-sheets)

[See all articles →](/blog/articles)

## Book a call

You are booked. The invitation is on its way to , with the calendar invite and the meeting link.

[Reschedule](#)

[Cancel](#)

## Schedule a meeting

## Schedule in person meeting at Data Outpost San Francisco

You are booked. The invitation is on its way to , with the calendar invite and the meeting link.

[Reschedule](#)

[Cancel](#)

## Links

Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link.

- [Google Sheets Tips](https://www.owox.com/blog/topics/google-sheets-tips) — /blog/topics/google-sheets-tips.md
- [Vadym Kramarenko](https://www.owox.com/team/vadym-kramarenko) — /team/vadym-kramarenko.md
- [Book a Demo](https://www.owox.com/book-a-call) — /book-a-call.md
- [JOIN and TEXTJOIN](https://www.owox.com/blog/articles/join-textjoin-functions-google-sheets) — /blog/articles/join-textjoin-functions-google-sheets.md
- [SUBSTITUTE](https://www.owox.com/blog/articles/substitute-function-google-sheets) — /blog/articles/substitute-function-google-sheets.md
- [text wrapping](https://www.owox.com/blog/articles/how-to-wrap-text-google-sheets) — /blog/articles/how-to-wrap-text-google-sheets.md
- [REPT](https://www.owox.com/blog/articles/rept-function-google-sheets) — /blog/articles/rept-function-google-sheets.md
- [SPARKLINE](https://www.owox.com/blog/articles/sparkline-google-sheets) — /blog/articles/sparkline-google-sheets.md
- [COUNTIF](https://www.owox.com/blog/articles/countif-and-countifs-google-sheets) — /blog/articles/countif-and-countifs-google-sheets.md
- [TRIM](https://www.owox.com/blog/articles/trim-clean-t-functions-google-sheets) — /blog/articles/trim-clean-t-functions-google-sheets.md
- [LEN](https://www.owox.com/blog/articles/len-function-google-sheets) — /blog/articles/len-function-google-sheets.md
- [CONCATENATE and the ampersand](https://www.owox.com/blog/articles/concatenate-and-ampersand-google-sheets) — /blog/articles/concatenate-and-ampersand-google-sheets.md
- [TEXT](https://www.owox.com/blog/articles/text-function-google-sheets) — /blog/articles/text-function-google-sheets.md
- [OWOX Data Marts](https://www.owox.com/app-signup)
- [spreadsheet reporting](https://www.owox.com/features/spreadsheet-reporting) — /features/spreadsheet-reporting.md
- [Google Sheets Tips · Pivot Tables in Google Sheets: How to Create and Use Them · October 2, 2026](https://www.owox.com/blog/articles/pivot-tables-google-sheets) — /blog/articles/pivot-tables-google-sheets.md
- [Google Sheets Tips · QUERY with CONCATENATE in Google Sheets: Join Two Columns · October 2, 2026](https://www.owox.com/blog/articles/query-with-concatenate-google-sheets) — /blog/articles/query-with-concatenate-google-sheets.md
- [Google Sheets Tips · QUERY with IMPORTRANGE in Google Sheets: Formula, Examples · October 2, 2026](https://www.owox.com/blog/articles/query-with-importrange-google-sheets) — /blog/articles/query-with-importrange-google-sheets.md
- [See all articles →](https://www.owox.com/blog/articles) — /blog/articles.md