Clay Icon
Join the Community
01 Community General

How to Split Full Name Column into First and Last Name in Excel

Avatar of Corey G.Corey G.
·
·

Hi guys, how I do I split a full name columns into two columns, first and last name

2 comments

  • Avatar of Fabian H.
    Fabian H.
    ·
    ·

    formula should work, where you can for example prompt it to just split on the first space

    👍1
  • Avatar of Mahmona
    Mahmona
    ·
    ·

    Hey Vatsal! Voltic.agency , We provide expert VAs with a strong background and working experience at cost-effective rates. (Mehmona)

How to Split Full Name Column into First and Last Name in Excel | Clay