I have a Column
Title, and need to get its length but not counting any spaces.
This is a test should give me the length of
LEN I can get the length of a string, but with the spaces. After searching a little bit I had the idea to replace all spaces with blank. But there is no
Replace Function I could use.
Replace Function that is build in can't be used that way, because I can only replace a specified character (via index) with another.
But I want to go over the
Title and replace every occurring space with blank.
How is this possible?