Playback starts YouTube’s embedded player (privacy-enhanced mode).
How to Split full Name to First and Last Name in Excel
Channelpc shastraDescription from the creator
Extract first name and last name from full name easily. To split full name into first name and surname we need left, right, find and len function. Using these formulas we can able to separate first name and surname. This tutorial will explain how to follow these steps.
About this tutorial
pc shastra published this 5:50 video tutorial on October 26, 2016. It has been watched 362,931 times on YouTube.
- Channel
- pc shastra
- Category
- Howto & Style
- Duration
- 5:50
- Published
- October 26, 2016
- Views
- 362,931
- Likes
- 1,571
Tags
Share
This tutorial in other languages
- FRComment diviser Nom complet pour Prénom et nom dans Excel
- ESCómo dividir Nombre completo Nombre y Apellido en Excel
- PTComo dividir Nome completo Nome e sobrenome no Excel
- ITCome dividere nome completo di Cognome e Nome in Excel
- DEWie nach Split vollem Namen: Namen und Vornamen in Excel
- NLHoe maak je volledige naam Split aan voor- en achternaam in Excel
- RUКак разделить полное имя на имя и фамилию в Excel
- PLJak podzielić pełna nazwa na imię i nazwisko w Excelu
- JAExcelの最初と最後の名にフルネームを分割する方法
- ARكيفية تقسيم الاسم الكامل إلى الاسم الأول والأخير في Excel
- HIकैसे Excel में प्रथम और अंतिम नाम के लिए पूरा नाम विभाजित करने के लिए
- IDCara Berpisah Nama penuh untuk Pertama dan terakhir Nama di Excel