Format excel

Im trying to automate formatting an excel. I did it using automation for excel and it takes a lot of time.
Things I wanted to do-

  1. if there are multiple values separated by comma i.e - abc, efg, hij in one cell, it has to be like this(insert in subsequent cells)
    and the cell with comma has to be deleted
    Then again same process if there are cells with comma and values.
  2. Changing a complete column of text case to title case
  3. Inserting empty cells with value like hello/hi

The automation i wrote opens and closes excel file 3 times for each of this process and consumes time.
can some one help me how to do it in less time.

i have attached the file I created for reference.

FormatExcel.xaml (28.1 KB) Output_file.xlsx (19.0 KB)

Hi @Inkittuserme_i
can u explain ur requirement please?

pls find the notes i added.

Hi @Inkittuserme_i !
Would you mind trying to use this workflow and letting us know if it has the right output ?
FormatExcel.xaml (22.3 KB)
I did not try it, so there may be errors

Thank you so much.
But i get one error at removing row which has comma(,). I tried solving it, but no, i couldnt. I deleted that assign activity, but still this error is thrown. Can u pls provide a solution? Thanks in advance
RemoteException wrapping System.InvalidOperationException: Collection was modified; enumeration operation might not execute.

hi… pls help me with the error i stated in above thread.

Hi ! Sorry I did not have time recently. Would you mind showing me the error ? It doesn’t show me any error

This is the error im getting

hi… did u get a chance to see it?
Pls let me know if u have any solution.
thanks in advance