


Since I want the resulted data to be displayed in the same cell, I have selected A1 as the starting cell and now click on FINISH. Step 5: Now select the result destination cell under the Destination section. So I will tell excel that I want the separator a straight slash (|) sign and click on NEXT to continue. After every heading, we have a straight slash sign (|) if you observe the data. Here we need to mention on what basis we are splitting the cell.
