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]}
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]}
OMG LOL, that was so simple, thanks