How to Split Text in Single Column to Multiple Columns ??

The Input Data in Excel as ;

Now we want to split the Data which is available in the Column "A" into Different Columns Based on the Delimiter "/".

For this Scenerio,We Can Use Modren Excel Activity.

i.e., Text To Columns Activity

Source Range : the column that contains the text to split.Here we have the input Data from "A2:A6"

Destination : where you want the split data to appear.Here we mentioned the range From "B:F"

Delimiter : the character that separate the data.Here We are Separating the text with Delimeter "/"

Final Output :