I want to remove all leading and trailing spaces from ALL cells in a datatable. I have an idea where I can probably use nested for-each loop, but I am not sure exactly how to do this. I first thought about something like: for each column in dt_Example.Columns: __for each row in column ____Assign…

Hi @tomato25 , I have attached the below xaml for your reference. check if it meets your requirements. Excel.zip (21.5 KB)

How to remove leading and trailing spaces from all cells in DataTable?

AshwinS2 (Ashwin S) June 15, 2019, 5:07am 2

Try the below post

Thanks
Ashwin.S

1 Like

Topic		Replies	Views
Remove leading spaces without using loops Activities excel , uiautomation , activities , question	3	1100	November 19, 2020
How to trim whitespaces from column names in datatable Help	32	6236	December 27, 2021
Remove all spaces from a datatable Help excel	4	5897	March 8, 2018
Remove space from lastrow in a datatble Academy Feedback	1	1189	May 8, 2019
Delete unwanted spaces in all cells in Datatable Studio	8	8455	May 29, 2020