Good afternoon.
Im trying to remove spaces on my excel. The first and last row works but the 2nd and 3rd rows not removing spaces. i used myvariable.replace(" ", “”). Find attached excel sheetTest.xlsx (9.2 KB)
Good afternoon.
Im trying to remove spaces on my excel. The first and last row works but the 2nd and 3rd rows not removing spaces. i used myvariable.replace(" ", “”). Find attached excel sheetTest.xlsx (9.2 KB)
Hello @Tapiwa,
The 2nd and 3rd rows contains nonbreaking spaces.
Replace myvariable.replace(" “, “”) with Regex.Replace(myvariable,”\s",“”).
Thanks @LiDo. It worked .
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.