Excel - Text to columns

[Paulina]

Hi,

I’m new in UiPath and I need to split the text into cells.

I found a similar solution on the forum:

Excel Split Column

I have attached a sample excel file, I’m trying to split the excel column. In the user name column there are names and after the name there is a number that begins with N. I need to take the number that begins with N and split it and add it into the number column while keeping the names in the User Name Column. Any help or workflow would be appreciated. matchtest.xlsx (10.5 KB)

but still can’t find a solution to my problem. Please help.

[Gresilda_Balla]

try to read the cell and then split the string you will get Split(“string” , “,”)
for each item in the array that you got from splitting the string use write cell

[kadiravan_kalidoss (Kadiravan K)]

Hi @Paulina,

Try this Xaml:
SplitExcel.xaml (13.0 KB)

Sample Output refer Sheet2:
Data.xlsx (10.9 KB)

Thanks!

[Paulina]

Hi @kadiravan_kalidoss

Yes. This is what I needed. Thank you so much!