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
Bookmarks