Split Full Names in Excel with TEXTBEFORE & TEXTAFTER.

Описание: Want to extract first, middle, and last names from a single cell in Excel? This quick tutorial shows you how using three simple formulas:

✅ First Name: =TEXTBEFORE(D3, " ")
✅ Middle Name: =TEXTBEFORE(TEXTAFTER(D3, " "), " ")
✅ Last Name: =TEXTAFTER(D3, " ", 2)

Perfect for cleaning up name columns, prepping datasets, or building smarter dashboards.
🎯 Works best when names follow a consistent format.