Mastering LEFT, RIGHT & MID in Excel – Extract Text Like a Pro

Want to pull out specific parts of text in Excel? Use LEFT, RIGHT, and MID to extract names, codes, dates, and more.

🔹 Syntax:

• =LEFT(text, num_chars)

• =RIGHT(text, num_chars)

• =MID(text, start_num, num_chars)

🔹 Examples:

• LEFT: Extract the first 4 digits of an ID →

  =LEFT(A2, 4)

• RIGHT: Get last 3 characters of a code →

  =RIGHT(B2, 3)

• MID: Pull middle part of text →

  =MID(C2, 6, 5)

🔹 Use Cases:

• 📩 Extract name from email
• 🆔 Get last digits of student ID
• 🔎 Separate parts of a string or code

🔹 Pro Tip:

Combine with FIND or SEARCH to locate dynamic positions:

=LEFT(A2, FIND("@", A2)-1)

🔚 Wrap-Up:

With LEFT, RIGHT, and MID, you can manipulate text easily and automate cleanup for reports, forms, and analysis.

📌 Save this post and follow @ScriptDataInsights for more Excel text formulas, automation tips, and productivity hacks!