R Robbedoes New Member Aug 19, 2011 #1 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.
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.
Luke M Excel Ninja Staff member Aug 19, 2011 #2 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.
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.
