Clay Icon
Join the Community
02 Support

Easy Method to Split Full Name into First and Last Name Columns

Avatar of Tyler M.Tyler M.
·
·

There has to. be an easy way to convert full name into separate first name and last name columns, yeah?

3 comments

  • Avatar of Tyler M.
    Tyler M.
    ·
    ·

    Thank you - this helped!

  • Avatar of Owen C.
    Owen C.
    ·
    ·

    Hey Tyler, thanks for reaching out! Absolutely, do you mind sharing the table you are working on? You can accomplish this by using a formula column and generating a REGEX formula to split and extract this data using our AI formula generator. Here is a video that shows this process: Loom Video Let me know how this goes and how else I can assist :)

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.