Getting First and Last Name Columns Instead of Full Name: Is It Possible?

I usually use gpt to filter them

Hey Aviv Farhi, do you already have a list of full names?

use the formula generator to split before and after the space in the full name string

👇🏻

Aviv Farhi You can also do this in Excel Assuming your full name data is in Column A and you want first names in Column B and last names in Column C: Copy =LEFT(A1, FIND(” “, A1) - 1) in the first cell of Column B Copy =RIGHT(A1, LEN(A1) - FIND(” “, A1)) in the first cell of Column C Drag down on both columns to apply for all names

--

Joe Hannon Just a tip: using formula columns won’t use credits.

Brandon Charleson Good call, missed that

No worries! 😉

Thanks everybody 🙌 FYI Clayteam for this link that was shared here https://www.clay.com/learn/how-to-use-ai-formulas The text Overview isn’t relevant to the video content, I guess it’s a mixup, I would be happy to see the video clip going over “Using Advanced Google Searches with Clay” if there is one ✌️