Spaces

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","").

1 Like

Thanks @LiDo. It worked .

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.