Split option to grab first name only or last name

Hello i am trying to use the spli option for to grab the first name

First name: Aldo Barahona

but when i do that is only grabing "A"

{=split({site: text; page= Example page},"")[1]}

You want to split by a space. Try this:
{=split({site: text; page= Example page}," ")[1]}

1 Like

OMG LOL, that was so simple, thanks :slight_smile: