Remove First & Last Letters From Text in Excel

Need to clean up your text in Excel by removing the first and last letters or characters? In this quick tutorial, I’ll show you how to do it using simple Excel formulas. 🧠 Formulas Used: 👉 To remove first letter only: =RIGHT(A1, LEN(A1)-1) 👉 To remove last letter only: =LEFT(A1, LEN(A1)-1) 👉 To remove both first and last letters: =MID(A1, 2, LEN(A1)-2) 💡 Works perfectly for: Cleaning up labels like A)John, B)Smith Removing unwanted characters from imports Processing survey or form entries ⚠️ Excel file is shown in the video — no download required. 📌 Works in Excel 2013, 2016, 2019, 2021, and Office 365 👍 Like, comment, and subscribe for more Excel shortcuts and formulas! #ExcelTips #TextFunctionsExcel #RemoveCharacters