Remove character spaces from a string

Hey all,

Not really a question but in response to a lot of posts re. REPLACE() not working as expected, thought I'd share this:

REPLACE({value}," ", "\u200B")

\u200B removes character spaces in {value}

Hope this helps!

Andy

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Community Advisor

Very nice, Andy!

Duly noted for future consideration: thanks for sharing!

Regards,

Doug

Sign up