Excel, delete space in a column

Help Studio
1

Hey Guys,

within a excel sheet, I would like to delete all spaces within a column.
Doing it by hand I would use Strg and F and would replace the space with nothing.

Thankyou,

Rebekka

2

Hey @rebekka.haendel
Hope you are doing well,

Try This!
row(“yourColumnName”).ToString.Replace(" “,”")

Cheers
@rebekka.haendel

1 Like
3

Hello, how do I follow a path for only leading and trailing spaces?