Extract texts from cell to multiple cells?

Hi ExcelForumians, it's been a while since I had forgotten my password.

Anyway, despite the title, I have no clue of what I'm actually doing.

For some reasons, I have got myself a sheet (Sheet1) with few hundreds of cells (A2: A) filled with texts that look like this.

10/02/2018
Show/S45/Paid
Res/Jan18/2018
NoShow/F01/Paid
RoS/S13,S14,S15/Paid
And many more.

Here is the problem. What I have to do is extract them into three cells like this.

(B2)10 (C2)02 (D2)2018
(B3)Show (C3)S45 (D3)Paid
(B4)Res (C4)Jan18 (D4)2018
(B5)NoShow (C5)F01 (D5)Paid
(B6)RoS (C6)S13,S14,S15 (D6)Paid

As you may see. The "/" is used to divide texts into 3 parts. And I had this done by hands for almost thousand cells by now.
Help me, please.

Heres a pic.
Sc1.png

There is an Text to columns option under the Data menu.

there you can select a separator value and the data will be separated into different columns for all selected cells of column A

https://support.office.com/en-us/art...a-7a3e9c363ed7

Holy ****. That was amazingly easy. Thank you!