How can I extract first and last names from a full name column in Stackby?
Hey Harsh,
You can use formulas in Stackby to split a full name into first and last names. Here’s how:
-
Use this formula to extract the first word (assumed to be the first name) from a full name
REGEX_EXTRACT(Name, "^[^ ]+") -
Use this formula to extract everything after the first name:
REPLACE(Name, 1, LEN(REGEX_EXTRACT(Name, "^[^ ]+")) + 1, "")
