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

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