How to split data with spaces from one cells into multiple in excel?

Hi all, I m trying to split data from single cell into multiple cells using delimiters in excel.But I got errors.Please provide .xaml for this query

Hi @Balasundari

What is the error?
Can you give me some sample.

hy buddy!
i too have same doubt how to split the data in a single cell

Assignment2.xlsx (10.7 KB)

this is my excel file i need to split the Role column as Dev as a separate one and TechR as separate one
Anyone please help me