Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation, Need text any length no spaces
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation - no dups and text length requirement | Excel Worksheet Functions | |||
limit text length after importing data | Excel Worksheet Functions | |||
Data Validation List Length | Excel Worksheet Functions | |||
CELL IS BLANK BUT NEED IT FILLED WITH SPACES TO A SPECIFIC LENGTH | Excel Worksheet Functions | |||
CELL IS BLANK BUT NEED IT FILLED WITH SPACES TO A SPECIFIC LENGTH | Excel Worksheet Functions |