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

[Simon_Robinson]

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