Menü

how to split full name to first name and last name facebook paylaş how to split full name to first name and last name twitter paylaş how to split full name to first name and last name google plus paylaş how to split full name to first name and last name linkedin paylaş
12.12.2016
Monday


how to split full name to first name and last name


Hi,

A1
Erick Aybar
Jennifer Lopez
Adriana Lima

B1
=RIGHT(A1;LEN(A1)-FIND(" ";A1))
ENTER

C1
=RIGHT(A1;FIND(" ";A1)-1)
ENTER

that's all




[ ADD COMMENT ] [ PRINT ]
Keywords: excel, split cell, name, surname

Writing by Aybar Dumlu