Excel formula to split the text

问题:

I need to split the below text like given below using Excel formula.

回答1:

Edit : I misread your question and provided different solution earlier. Here's is the formula

=TRIM(MID(SUBSTITUTE($A1,"/",REPT(" ",999)),(COLUMN(A:A)-1)*999+1,999))

回答2:

Do you need formulas? I think text to column would work much better. Just set / as the delimiter and split column A. After, do a clean-up by looking for and removing spaces.