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