Separating Middle Name from List of Names Tutorial (Mid and Len Formulas w/ Find and Replace) Excel
Hi everyone!
Here is the follow-up video from last video which covered just the first and last name splitting. Here we cover what to do if our list includes a middle name or middle initial.
The Formula used for the cutting of the first name
=mid(select cell w/ full name, len(select cell w/ first name) + 2, len(select cell w/ full name))
*Please note that the bolded will be cell references when you use them in your sheet.
Link to last video
• Separating First and Last Names (Wildcards...
Please let me know if you have any questions!
Thanks for watching!