Need suggestions on data formatting in excel

I am new UI Path, I have improper data format in a excel so i need to do formatting according that is like select Column “A” fully in same excel and go to “Data” at ribbon pane and click on Text to columns so that excel format will change. Any one help me how to do this using ui path.

Thanks in advance.


I would suggest that you use vba to format your data, than use UiPath, to invoke the vba code.

i need this actvity to perform in ui path

could anyone mention how to do this in ui path???

documentRecon.docx (20.8 KB)