How to apply a formula that separate an output from 1 column in two.

·

· Sorted by Oldest

Aamir B.
·
·
https://app.clay.com/workspaces/199708/tables/t_hsdwFYg7aDDA/views/gv_sGbaJpC4XNJ2
Jani V.
·
·
Hey Aamir, I don't think you can solve this with only one formula let's say column a is full name, you want to split it into first name and last name
you need to set up column B, to get the first name
and also set up column C, to get the last name
👍1
🔥1
Jani V.
·
·
hope it helps!
Clay Team
APP
·
·
Thas correct! would look like this:
f4608c92-aa6c-40cf-b04b-bca5235a1d5f.png(70 kB)
🔥1
Clay Team
APP
·
·
Yup!! In case it helps -> Here's a video of how to Split or Combine names (and more) with formulas: https://www.loom.com/share/75cf18efe4bf47979c6b4868d1594e6c

Aamir B.
·
·
https://app.clay.com/workspaces/199708/tables/t_hsdwFYg7aDDA/views/gv_sGbaJpC4XNJ2
Jani V.
·
·
Hey Aamir, I don't think you can solve this with only one formula let's say column a is full name, you want to split it into first name and last name
you need to set up column B, to get the first name
and also set up column C, to get the last name
👍1
🔥1
Jani V.
·
·
hope it helps!
Clay Team
APP
·
·
Thas correct! would look like this:
f4608c92-aa6c-40cf-b04b-bca5235a1d5f.png(70 kB)
🔥1
Clay Team
APP
·
·
Yup!! In case it helps -> Here's a video of how to Split or Combine names (and more) with formulas: https://www.loom.com/share/75cf18efe4bf47979c6b4868d1594e6c