No simple SUBSTITUTE in macros?

[eobet]

I just want to remove all spaces from a text cell in a (user code) macro, but it seems I either have to use complicated regular expressions, or create a multi-line search and replace descriptor…

Is there no simple equivalent to substitute that I missed?

[erAck]

The Replace() function.

[eobet]

Thank you!

So very difficult to find sensible search results when you’re starting out learning about something completely new.