✅ Text Functions in Excel ✂️📄

Text functions help clean, extract, and format text data. Useful for cleaning names, splitting columns, or preparing reports.

1️⃣ LEFT, RIGHT, MID
⦁ LEFT(text, num_chars): Get characters from start
⦁ RIGHT(text, num_chars): Get characters from end
⦁ MID(text, start_num, num_chars): Extract middle part
Example:
=LEFT("Excel", 2) → Ex
=RIGHT("Excel", 2) → el
=MID("Excel", 2, 2) → xc

2️⃣ LEN
Returns number of characters in a string.
=LEN("Excel") → 5

3️⃣ FIND & SEARCH
Finds position of text.
⦁ FIND is case-sensitive
⦁ SEARCH is not
=FIND("x", "Excel") → 2
=SEARCH("X", "Excel") → 2

4️⃣ TRIM
Removes extra spaces.
=TRIM(" Excel ") → Excel

5️⃣ CONCAT & TEXTJOIN
⦁ CONCAT: Joins values
⦁ TEXTJOIN: Joins with a delimiter
=CONCAT(A1, B1) → No space
=TEXTJOIN(" ", TRUE, A1, B1) → Adds space

6️⃣ UPPER, LOWER, PROPER
⦁ =UPPER("excel") → EXCEL
⦁ =LOWER("EXCEL") → excel
⦁ =PROPER("hello world") → Hello World

7️⃣ SUBSTITUTE & REPLACE
⦁ SUBSTITUTE: Replace specific text
=SUBSTITUTE("2023-11-25", "-", "/") → 2023/11/25
⦁ REPLACE: Replace based on position
=REPLACE("Excel", 2, 2, "++") → E++el

8️⃣ VALUE & TEXT
⦁ VALUE("100") → Converts text to number
⦁ TEXT(1234.5, "#,##0.00") → 1,234.50

💡 These are essential for data cleaning, reporting, and automation in Excel.

💬 Tap ❤️ for more!