Link to page

Split First and Last Names with One First Name

Thank you
`Jean_Pierre_Traets`⁠
for this post:
`Parsing First/Last Name Issue`⁠
⁠

First and Last Names

First and Last Names

Full Name

First Name

Last Name

Ben Lee

Ben

Lee

Al Chen

Chen

Joe Dimento

Joe

Dimento

There are no rows in this table

⁠

[First Name] Formula: Left([Full Name],Find(" ",[Full Name])-1)

[Last Name] Formula: Right([Full Name],Length([Full Name])-Find(" ",[Full Name]))

Split First and Last Names with Multiple First Names

Thank you
`shishir`⁠
for this post:
`Parsing First/Last Name Issue`⁠
⁠

First and Last Names - 2 First Names

First and Last Names - 2 First Names

Full Name

First Name

Last Name

Ben Lee

Ben

Lee

Al Chen

Chen

Joe Dimento

Joe

Dimento

Billy Bob Thornton

Billy Bob

Thornton

There are no rows in this table

⁠

[First Name] Formula: [Full Name].Split(" ").Slice(1,-2).Join(" ")

[Last Name] Formula: [Full Name].Split(" ").Slice(-1,-1).Join(" ")

Capitalize the first letters of first and last name (Title Case / Camel Case / Capital Case / Proper Case)

Thank you
`Asaf_Dafna`⁠
for this post:
`Capitalize the first letters of first and last names`⁠
⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.