You can use data validation.
As validation criteria use a custom formula:
=ISERROR(FIND(" ",A1))

Above formula results in TRUE if the input value of A1 ontains no spaces.
(The FIND tries to find a space, finds none and results in error. ISERROR
results in TRUE = input is valid)

Cheers,

Joerg Mochikun


"BB" wrote in message
oups.com...
I'd like to know if anyone knows how to set up data validation so that
a user is forced to enter text without spaces. For example:

J 23 45 should be J2345

I'm not concerned about placing restrictions on the length, just that
there are no spaces in the text entered.

Any help someone could offer would be appreciated.

Thanks,
BB