I am trying to figure out how to create a formula for a string.
I would like to remove everything after the first set of numbers, with no spaces:
Can someone help me?
Formulas are not my strong suit.
Try this formula format:
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, "[^ ]*"))
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
@M_k You can also do this without using REGEX at all:
Oops - I guess killing time on the forums late at night might not be the best idea for me lmao.
This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.