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.
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: