How to Split First and Last Name in Excel

There are a few ways to split a first and last name in Excel. One way is to use the TEXTJOIN function. The TEXTJOIN function will allow…

There are a few ways to split a first and last name in Excel. One way is to use the TEXTJOIN function. The TEXTJOIN function will allow you to join text values together, and it will allow you to specify a delimiter. In this case, you would use a space as the delimiter. Another way to split a first and last name is to use the TRIM function. The TRIM function will remove any spaces at the beginning or end of a text value. Finally, you could use the SUBSTITUTE function. The SUBSTITUTE function will allow you to replace a text value with another text value. In this case, you would use a space as the replacement text.

PERSONAL FINANCE
Buy vs Rent
Should you buy a house or rent?
Startur
B2B SaaS Revenue
Forecast your inbound and outbound leads to determine revenue, and understand what kind of sales funnel you need to hit your revenue targets.
FINANCE
Detailed Headcount Model
Understand the breakdown of your headcount and payroll costs by Department (Sales, Engineering, etc.) and plan your future hires.
Excel

How to Split First and Last Name in Excel

How to Split First and Last Name in Excel

There are a few ways to split a first and last name in Excel. One way is to use the TEXTJOIN function. The TEXTJOIN function will allow you to join text values together, and it will allow you to specify a delimiter. In this case, you would use a space as the delimiter. Another way to split a first and last name is to use the TRIM function. The TRIM function will remove any spaces at the beginning or end of a text value. Finally, you could use the SUBSTITUTE function. The SUBSTITUTE function will allow you to replace a text value with another text value. In this case, you would use a space as the replacement text.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.
​