SyntaxFix
Write A Post
Hire A Developer
Questions
It is SUBSTITUTE(B1," ",""), not REPLACE(xx;xx;xx).
SUBSTITUTE(B1," ","")
REPLACE(xx;xx;xx)