SPLIT CONTENTS IN DIFFERENT CELL IN EXCEL
STEPS :
Select the cell or column that contains the text you want to split.Click on Data TabClick Text to Columns.In the Convert Text to Columns Wizard, select Delimitedclick Next.
Select the Delimiters for your data. For example Comma, Space etc. You can see a preview of your data in the Data preview window. here we choose spaceClick Next.
Choose the Column data format or use what Excel choose for you. Here we choose General.Select the Destination, which is where you want the split data to appear on your worksheet.Click finish