Anyone know how to remove spaces from a strin...

(Simon Robinson) #1

Anyone know how to remove spaces from a string of text?

I’m trying to check if a car registration number exists.

Sometimes the user will type AB12 CDE and other times AB12CDE.

Appsheet see’s these as different.

Tried Concatenate(Split([Reg]," ")) but I just end up with AB12,CDE

:frowning:

(Aleksi Alkio) #2

You can use SUBSTITUTE expression.

(Simon Robinson) #3

Magic, Substitute([Reg]," “,”") works great

(Aleksi Alkio) #4

You’re welcome