Google-sheets – Split function doesn’t get the result that I expect

formulasgoogle sheetsregexextract

A1 value is 485065/1, 2, 3 and I expect 485065 and 1, 2, 3
but it comes out 485065 and 1, 2, 2003.

=split(a1,"/",false)

Please help me why it does.

Best Answer

  • use REGEXEXTRACT instead:

    =REGEXEXTRACT(A1, "(.)/(.)")

    0