QuitExams

Introduction

Text functions in LibreOffice Calc and Excel help manipulate and analyze textual data — extracting characters, joining text, converting case, and more. These functions are essential for cleaning and preparing data for reporting and automation.

1️⃣ LEFT Function

Purpose: Extracts a specified number of characters from the left side of a text string.

Formula: =LEFT("LIBREOFFICE";5)

Result: LIBRE

2️⃣ RIGHT Function

Purpose: Extracts a specified number of characters from the right side of a text string.

Formula: =RIGHT("SPREADSHEET";5)

Result: SHEET

3️⃣ MID Function

Purpose: Extracts characters from the middle of a text string, starting at a specified position.

Formula: =MID("CALCULATOR";3;4)

Result: LCUL

4️⃣ LEN Function

Purpose: Returns the total number of characters in a text string.

Formula: =LEN("LibreOffice")

Result: 11

5️⃣ FIND Function

Purpose: Returns the position of a substring within a text string (case-sensitive).

Formula: =FIND("O";"LibreOffice")

Result: 6 (because "O" appears at the 6th position)

6️⃣ CONCATENATE Function

Purpose: Joins two or more text strings into one.

Formula: =CONCATENATE("Hello ","World!")

Result: Hello World!

7️⃣ TEXTJOIN Function

Purpose: Joins multiple text items using a delimiter (available in newer Calc versions).

Formula: =TEXTJOIN(", ";1;A1:A3)

Example Data:

Result: Apple, Banana, Cherry

8️⃣ PROPER Function

Purpose: Converts text to proper case (first letter capitalized).

Formula: =PROPER("welcome to quitexams")

Result: Welcome To Quitexams

9️⃣ LOWER Function

Purpose: Converts all text to lowercase.

Formula: =LOWER("HELLO WORLD")

Result: hello world

🔟 UPPER Function

Purpose: Converts all text to uppercase.

Formula: =UPPER("hello world")

Result: HELLO WORLD

1️⃣1️⃣ REPT Function

Purpose: Repeats text a specified number of times.

Formula: =REPT("*";10)

Result: **********

📊 Summary Table

Conclusion

Text functions simplify data preparation by allowing flexible text transformation, case conversions, and joining operations. These are especially useful in reports, form templates, and data cleaning tasks.