How to Split Cells with Formulas in Excel

Опубликовано: 19 Сентябрь 2024
на канале: Excel Campus - Jon
86k
681

Sign up for our Excel webinar, times added weekly:
In this video, I show you how to use formulas in Excel to split full names into first and last names. I use functions such as RIGHT, LEFT, SEARCH, and LEN to do this.
If you’d like to read the accompanying blog post on my website, you can access it here:

0:00 Intro
1:12 Extract First Name
5:14 Extract Last Name
8:33 Pros & Cons of Formula Technique

Related Videos:
How to Split Cells & Text in Excel with Power Query:

Split Cells with Text to Columns in Excel: