Summary  
This chapter explains how to use text functions to measure the length of strings, substitute parts of a string, concatenate multiple strings into one, and split a string by a specified delimiter.  

General domain of usage  
Data cleaning and formatting

## **Calculating Length**

The **LEN** function returns the number of characters in a string, including spaces. This function is useful for analyzing the length of textual data, such as when checking whether entered text meets a character limit.

## **Substituting Text**

The **SUBSTITUTE** function replaces all or some occurrences of a part of a string with another text. It is useful for correcting typos or replacing data, such as replacing outdated values with current ones.

## **Concatenating Text**

The **CONCATENATE** function combines two texts or strings into one. This is useful for joining data from different cells, such as last names and first names, or other pieces of information.


## **Splitting Text**

The **SPLIT** function divides a string into multiple parts using a specified delimiter. This is useful for breaking down data, such as a list of words, dates, or complete sentences.


### **Task: Working with LEN, SUBSTITUTE, CONCATENATE, and SPLIT Functions**  

You have the following spreadsheet formulas:  

| A  | Formula | Expected Result |
|----|---------|----------------|
| Codefinity | `=LEN(A1)` | ? |
| banana | `=SUBSTITUTE(A2, "a", "o", 2)` | ? |
| Code | `=CONCATENATE(A3, " ", "Master")` | ? |
| Apple;Orange;Banana | `=SPLIT(A4, ";")` | ? |

Which of the following answer choices correctly fills in the expected results?  

Learn how to create and customize spreadsheets in Google Sheets, work with formulas and functions, including logical operations, format data, and sort and filter information. Master data visualization with charts and ensure data security during collaboration.

Learn how to create, rename, copy, delete, move, and download spreadsheets in Google Sheets. Acquire basic skills for organizing and managing data in a cloud-based environment.

Master the basics of editing and formatting data in Google Sheets. Learn how to adjust fonts, borders, colors, merge cells, and resize rows and columns to create clean and professional-looking tables.

Enhance your cell formatting skills: learn how to split text into columns, add hyperlinks, images, notes, and forms. Explore creating interactive and dynamic spreadsheets.


Develop skills to sort, filter, and clean data efficiently. Learn to use search and replace, conditional formatting, remove duplicates, and create named ranges to analyze large datasets.

Discover how to build charts and graphs to visualize data. Learn to customize line, column, pie, and area charts for clear and insightful reporting.

Understand the core functions in Google Sheets for working with numbers, text, and dates. Learn to apply arithmetic, statistical, text functions, and date-time functions for automated calculations and data analysis.

Explore logical functions for conditional data analysis. Learn how to use AND, OR, IF, and conditional formulas like SUMIFS, COUNTIFS, and AVERAGEIFS to create flexible calculations.

Discover how to manage collaboration and secure data. Learn to set access permissions, create notification rules, protect sheets and ranges, track version history, and recover data.

A	Formula	Expected Result
Codefinity	`=LEN(A1)`	?
banana	`=SUBSTITUTE(A2, "a", "o", 2)`	?
Code	`=CONCATENATE(A3, " ", "Master")`	?
Apple;Orange;Banana	`=SPLIT(A4, ";")`	?

Text Functions

Calculating Length

Substituting Text

Concatenating Text

Splitting Text

Task: Working with LEN, SUBSTITUTE, CONCATENATE, and SPLIT Functions