Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring

i) .choose the column to split......In Data tab.....>.......text to columns....>delimeter..choose the delimeter to split click next

text_split function is not working in excel version so i have used left an6d right functions to split the text.