Text Functions
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, ";") | ? |
Bedankt voor je feedback!
Vraag AI
Vraag AI
Vraag wat u wilt of probeer een van de voorgestelde vragen om onze chat te starten.
Awesome!
Completion rate improved to 1.45Text Functions
Veeg om het menu te tonen
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, ";") | ? |
Bedankt voor je feedback!
