***Notification***
For some technical issues,I had to move on to new channel of Excel.This is the same excel channel of mine as you used watch.

In this video we will learn how to split First,Middle and Last Name in Excel using few formulas..

Formulas used are
=LEN
LEN returns the number of characters in a text string.

=LEFT
LEFT returns the first character or characters in a text string, based on the number of characters you specify.

=RIGHT
RIGHT returns the last character or characters in a text string, based on the number of characters you specify.

=REPLACE
REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string.

=SUBSTITUTE
Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string.

=SEARCH
The SEARCH function locates one text string within a second text string, and returns the number of the starting position of the first text string from the first character of the second text string.

To Download the file,click on the link

https://drive.google.com/open?id=1g6ThBKaTwvXdaW3rMTlT6Du-h31YPFko

My Excel Channel Link
https://www.youtube.com/channel/UC5S01OP1F24HbHRTX_IxfkA

My other Channel Link
https://www.youtube.com/channel/UCKxaqeTP4Y1mW1i6OJwXTNQ

Facebook:https://www.facebook.com/debasish.debnath.5201
Twitter :https://twitter.com/deba007007
Email :[email protected]

Please take the opportunity to connect and share this video with your friends and family if you find it useful.