yogi_Split Concacted Rows Of Data Into Columns By Name Date And Bet

Google Spreadsheet   Post  #1984

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-01-2015

post by  meph2u:
https://productforums.google.com/forum/#!topic/docs/egukDdSOXuM;context-place=forum/docs
Keeping original format in a split function (and a related arrayformula question)
In this spreadsheet:

https://docs.google.com/spreadsheets/d/12oE4nrLHrI5_I37DU3iFKvNae7xb2FIXg3Bt-Uavqf0/edit?usp=sharing

I split data like this:

Player

Rory McIlroy — 9/2 — BEST BET

Justin Rose — 8/1 — BEST BET

Brooks Koepka — 15/1 — BEST BET

Hideki Matsuyama — 15/1 — BEST BET

Justin Thomas — 30/1 — BEST BET

Tony Finau — 30/1 — BEST BET

Robert Streb — 30/1

Daniel Berger — 40/1 — BEST BET

Emiliano Grillo — 40/1 — BEST BET

Kevin Na — 40/1 — BEST BET

to get data like this:

Rory McIlroy	42249	BEST BET
Justin Rose	42217	BEST BET
Brooks Koepka	15/1	BEST BET
Hideki Matsuyama	15/1	BEST BET
Justin Thomas	30/1	BEST BET
Tony Finau	30/1	BEST BET
Robert Streb	30/1
Daniel Berger	40/1	BEST BET
Emiliano Grillo	40/1	BEST BET
Kevin Na	40/1	BEST BET

Unfortunately, having the 9/2 and 8/1 display as numbers or dates doesn't work for me.   Is there a way to get the cells in red to display 9/2 and 8/1?

Why does this formula in cell b2:  =iferror(split(A2,"—"))

Produce the same results as this formula in cell H2: =iferror(arrayformula(split(A2:A,"—")))

In other words, why doesn't the arrayformula work for all cells H2:H and what can I do to make it work?

Thanks!

------------------------------------------------------------------