Split name and surname in Excel (formula)
Опубликовано: 05 Август 2026
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
142
0
00:00 Split full name in single cell to first name and surname columns
00:05 Turn all upper case into proper case for capital at the start of each name
00:22 Split the name by the space delimiter (surname space first name)
00:57 Extract the first name based on the space between first name and surname
01:56 Extract the surname which is at the start of the cell
Excel formulas that will take a single column containing a surname and first name, split with a space, and split them into 2 different columns with the first name in its own column and the surname in its own column.