TEXTAFTER function in Excel

Today, we’re focusing on the TEXTAFTER function—a versatile tool that extracts text after a specified character or delimiter. If you’re already familiar with this function, feel free to skip today’s edition.

Without further ado, let’s dive in and explore how TEXTAFTER can simplify your text manipulation tasks in Excel!

1. Open Excel and Navigate to the Next Cell

Add a piece of the energy sector to your portfolio.

• Access to 300 million barrels of recoverable oil reserves

• Royalty-based investment model reducing operational risks

• Projected 25+ years of potential royalty income

Join the Raise

2. Type TEXTAFTER Function. =TEXTAFTER(B3,

The AI Boom Has Arrived—Don’t Miss Your Chance to Get In!

Artificial Intelligence is set to skyrocket into a $100 trillion industry, presenting savvy investors with a once-in-a-lifetime opportunity to profit. Renowned industry expert James Altucher shares his top strategies to help you capitalize on this trend. But time is of the essence—this “wealth window” on AI is closing rapidly! Act now to gain the upper hand before the rest of the world catches on.

Watch the Free Video Now

3. Type the delimiter. =TEXTAFTER(B3,”-”)

4. Drag it down to AutoFill

We are done. The TEXTAFTER has been applied and all the text before the (-) string has been Extracted.

That’s how you can use the TEXTAFTER function in Excel to quickly extract text after a specific character or delimiter. Whether you’re working with product codes, email lists, or formatted data, this function can save time and streamline your text management.

We Value Your Feedback

Was this featured story helpful? Rate it, and let us know how we can improve.