Extracting Founders into Separate Columns in Excel

·

Hi, I would like to be able to extract founder 1 in one column, and the second in another column, how to extract this field? thx team:)

· Sorted by Oldest

Channeled
APP
·
·
💤 You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!
alex
·
·
i guess using formula is the easiest option though
Bo (Clay)
·
·
Hey, thanks for reaching out! 😊 You can easily extract the founders into separate columns. Here’s what you need to do: 1. Use the “Extract Values from Data” function. 2. Choose Custom extraction. 3. Apply this Regex: [^,"]+"?[^,"]+. This will help split the values into separate columns. Let me know if you need any more assistance! 👍 https://downloads.intercomcdn.com/i/o/1196807588/1f7229ba70f82d63aa8d6ac2/CleanShot%2B2024-09-28%2Bat%2B_31EcphMZQF-402x.png?expires=1727535600&signature=ae43e57b95bb0342909a65c801e8ec499003329e83b4aacf10b7c200c6daf821&req=dSEuEMF%2BmoRXUfMW1HO4zTW53TIcGbifYBI4XovFsVs6oyIs3Hq5fgzs9Zmu%0AUAYY%0A
alex
·
·
thx 🙂
Channeled
APP
·
·
Hi alex! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback alex!
Channeled
APP
·
·
Thank you so much for sharing your feedback alex!
Channeled
APP
·
·
Thank you so much for sharing your feedback alex!
Channeled
APP
·
·
Thank you so much for sharing your feedback alex!

Channeled
APP
·
·
💤 You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!
alex
·
·
i guess using formula is the easiest option though
Bo (Clay)
·
·
Hey, thanks for reaching out! 😊 You can easily extract the founders into separate columns. Here’s what you need to do: 1. Use the “Extract Values from Data” function. 2. Choose Custom extraction. 3. Apply this Regex: [^,"]+"?[^,"]+. This will help split the values into separate columns. Let me know if you need any more assistance! 👍 https://downloads.intercomcdn.com/i/o/1196807588/1f7229ba70f82d63aa8d6ac2/CleanShot%2B2024-09-28%2Bat%2B_31EcphMZQF-402x.png?expires=1727535600&signature=ae43e57b95bb0342909a65c801e8ec499003329e83b4aacf10b7c200c6daf821&req=dSEuEMF%2BmoRXUfMW1HO4zTW53TIcGbifYBI4XovFsVs6oyIs3Hq5fgzs9Zmu%0AUAYY%0A
alex
·
·
thx 🙂
Channeled
APP
·
·
Hi alex! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback alex!
Channeled
APP
·
·
Thank you so much for sharing your feedback alex!
Channeled
APP
·
·
Thank you so much for sharing your feedback alex!
Channeled
APP
·
·
Thank you so much for sharing your feedback alex!