Remove everything after first comma in an entire column of a datatable without for each

[Rahul_Unnikrishnan]

Hello @ammohan

You can use Read Range to read the excel and then use Output datatable to convert to string. The use Text to columns or Generate Datatable acitvity.

UiPath- Text to DataTable |Generate DataTable & Text to Columns activities

Thanks