• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Format a cell in Excel that way that spaces are not allowed

R

Robbedoes

New Member
Hi,

I like to format a cell into an Excel-file that way that the user cannot type the input with a space between the letters and/or ziphers. Any solution for that?

Thanks in advance.

Krgds.
 
Data - Validation.

Custom, Formula is:

=LEN(A2)-LEN(SUBSTITUTE(A2," ",""))=0


Change the cell reference to whichever cell you are actually putting the validation in.
 
You must log in or register to reply here.
Back
Top