Microsoft Excel came with many useful formulas one of them is separates name, in this article I will shows you how to separate full name into first name, middle name & last name in different cell. This formula will work all the version of Excel like 2003 to 2016. Just use the formula given below… Watch video for better understand..
Formula :
First Name : =LEFT(B3,FIND(" ",B3)-1)
Middle Name : =MID(B3,FIND(" ",B3)+1,FIND(" ",B3,FIND(" ",B3)+1)-FIND(" ",B3)-1)
Last Name: =RIGHT(B3,LEN(B3)-FIND(" ",B3,FIND(" ",B3)+1))
Note: (Replace the Cell Number with yours)
Watch video tutorial… Please like, share & subscribe
3 comments:
canada goose uk
kate spade handbags
coach outlet
salomon boots
ralph lauren outlet
ralph lauren shirts
supreme clothing
coach outlet
air max
adidas eqt
mens basketball shoes
goyard tote
adidas ultra boost
moncler jackets
cheap nfl jerseys
chrome hearts outlet
nike dunk low
kobe shoes
Your post is great and meaningful. Thank you for sharing this article. I would like to receive better and better articles.
Post a Comment