Hey @M_k!
Try this formula format:
REGEX_EXTRACT(
SUBSTITUTE(
{Label},
" ",
""
),
"[A-Za-z0-9]*"
)
It will produce something like this:

Let me know if you have any issues, questions, or just want a wider explanation!
@Ben.Young The requirement was to remove all characters after the space. Yours removes the space and the extension, but keeps the characters after the space.
@M_k This will do what you want:
IF(Label, REGEX_EXTRACT(Label, "[^ ]*"))

@Ben.Young The requirement was to remove all characters after the space. Yours removes the space and the extension, but keeps the characters after the space.
@M_k This will do what you want:
IF(Label, REGEX_EXTRACT(Label, "[^ ]*"))

Thank you so much, @Justin_Barrett and @Ben.Young!!
It’s the formula output from Justin’s, that will work for my use case. TY
Mary
@M_k You can also do this without using REGEX at all:
LEFT(text,FIND(" ",text)-1)
@Ben.Young The requirement was to remove all characters after the space. Yours removes the space and the extension, but keeps the characters after the space.
@M_k This will do what you want:
IF(Label, REGEX_EXTRACT(Label, "[^ ]*"))

Oops - I guess killing time on the forums late at night might not be the best idea for me lmao.