🔹 Basic Excel Text Formulas for Beginners (With Easy Examples)

Excel isn’t just for numbers — it can also handle text! These 10 text formulas help you clean, format, and combine text quickly and easily. Perfect for beginners who want to organize data like names, addresses, or product codes. Here is the ITInsite update for you

11. CONCATENATE (or CONCAT) – Join Text Together

Combines text from different cells into one.
Formula: =CONCAT(A1, ” “, B1)
👉 Example: If A1 = “John” and B1 = “Smith”, result = John Smith

12. TEXTJOIN – Join Text with a Separator

Joins text from multiple cells and adds a separator (like a comma or space).
Formula: =TEXTJOIN(“, “, TRUE, A1:A5)
👉 Example: Joins A1 to A5 as “Apple, Banana, Orange, Mango, Grape”

13. LEFT – Get Text from the Start

Takes a certain number of characters from the left side of a cell.
Formula: =LEFT(A1, 3)
👉 Example: If A1 = “Excel”, result = Exc

14. RIGHT – Get Text from the End

Takes characters from the right side of a cell.
Formula: =RIGHT(A1, 4)
👉 Example: If A1 = “Excel2025”, result = 2025

15. MID – Get Text from the Middle

Extracts text from the middle of a cell.
Formula: =MID(A1, 2, 5)
👉 Example: If A1 = “Learning”, result = earnin

16. LEN – Count Characters

Counts how many characters (letters, spaces, numbers) are in a cell.
Formula: =LEN(A1)
👉 Example: If A1 = “Excel”, result = 5

17. TRIM – Remove Extra Spaces

Cleans up extra spaces from text, leaving only single spaces between words.
Formula: =TRIM(A1)
👉 Example: “ Excel Tips ” becomes Excel Tips

18. UPPER – Make Text Uppercase

Converts all letters to capital letters.
Formula: =UPPER(A1)
👉 Example: “excel” becomes EXCEL

19. LOWER – Make Text Lowercase

Converts all letters to small letters.
Formula: =LOWER(A1)
👉 Example: “EXCEL” becomes excel

20. PROPER – Capitalize Each Word

Makes the first letter of each word uppercase.
Formula: =PROPER(A1)
👉 Example: “excel text formulas” becomes Excel Text Formulas

💡 Quick Tip:

These text formulas are perfect for cleaning up names, addresses, or lists.
Try combining them — for example:
=PROPER(TRIM(CONCAT(A1, ” “, B1)))
👉 This cleans spaces, joins names, and capitalizes properly! And stay tune with ITInsite to get more continue update….