Text to column using formula

[Julien1170]

Hi all,

Thanks in advance for anyone taking their time to help out!
I am an excel novice, who usually finds answers on google but this one is unfortunately too difficult to solve. I need to split information from one cell into 4 different columns using formula (trying to avoid the manual text to column option as everything else has be optimized).

- The information that needs to be split comes in the following format: 2000/100/200/300
- 2000 needs to go into column B, 100 into column C, 200 into column D and 300 into column E
- The numbers can range between 0-9999
- The following character always separates the numbers: /

Can anyone help?

[PaulM100]

Try this: =TRIM(MID(SUBSTITUTE($A2,"/",REPT(" ",LEN($A2))),(COLUMN(A1)-1)*LEN($A2)+1,LEN($A2)))

[Julien1170]

Thanks a lot! That seems to work although I don't understand it

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.