Hi All, Am trying to remove space in every value but i have a problem as there is no headers, empty cells available and few cell contain no space, so how can I over come with this process. Query.xlsx (8.1 KB) the Excel file for ur referance.

Hi @ragul.n , Could you give this workflow a try? [image] //Clears whitespaces from both ends (From row In dt.AsEnumerable() Let rlst = row.ItemArray.ToList() Let ra = rlst.ConvertAll(Function(c) c.ToString.Trim).ToArray() Select dt_res.Rows.Add(ra)).CopyToDataTable() RemoveSpacesAllCells.xaml …

Want to remove space in every cell in the Excel

Help Studio

anon87560229 January 3, 2023, 10:52am 4

Hi Users ,

use Replace regular expression…

Happy Automation …!!!

Topic		Replies	Views
How to remove whitespaces in the excel Studio studio , question , activities_panel	5	2137	August 1, 2022
Delete unwanted spaces in all cells in Datatable Studio	8	9307	May 29, 2020
Need to remove whitespace from datatable specific column Activities datatable , excel , selector , database , uiautomation , pdf , mail , orchestrator , robot , activities , studio , data_scraping , studiox , question , activities_panel	7	5294	February 11, 2022
How to remove white space in excel cell StudioX datatable , excel , uiautomation , data_scraping , string , studiox , question	5	2258	January 14, 2021
How can remove space between number Help excel , activities , studio	15	3881	February 22, 2019

Want to remove space in every cell in the Excel

Related topics