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

Help
#1

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

#2

Hi @Balasundari

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

#3

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

#4

Assignment2.xlsx (10.7 KB)

#5

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