How to Remove all Spaces from a Text
I would like to share a way of removing all spaces from a Text.
My text is [Text] = “Rogerio Plank Goulart” and I want to see this as “RogerioPlankGoulart”.
To do so, Replace all spaces (” “) with null (“”), use Replace([Text];” “;””).
You can either prefer to Show each part of the text in a separate line to do so, use Replace([Text];” “;Char(10)). It will show [Text] as