| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
restricting use of certain characters
Hi,
I'd like to know how to restrict entry of certain characters (those that windows won't allow when naming a file, particularly the / sign) EG, the person may want to enter 07/77147 into a cell and I want either a message to appear saying the / is invalid or, with an option for the / to be automatically changed to a -. Is this possible? Rob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I control the length of characters a code will return? | Excel Discussion (Misc queries) | |||
| Formula Needed to Omit Characters | Excel Worksheet Functions | |||
| Formula to replace invalid filename characters | Excel Worksheet Functions | |||
| Help - Can't directly input Japanese characters into cell | Excel Discussion (Misc queries) | |||
| HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT | Excel Worksheet Functions | |||
Threaded Mode
