Space Remove

Can you tell how can I remove the space from inside the column.

I don’t know what do you mean by “inside the column”.

Assuming it’s a field… AppSheet doesn’t remove characters, it replaces them with “nothing”, hope it makes sense.

SUBSTITUTE(
  "This is some text",
  " ",
  ""
)

Produces:

Thisissometext

1 Like

Will this function remove more space?

What do you mean?

1 Like

https://help.appsheet.com/en/articles/4286174-trim

1 Like