Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Avoid special characters
What should I do to share a workbook but not accepting special characters on
the different cells to be filled in? I'm refering to those characters like #$%& etc. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Avoid special characters
You could apply data validation (see my response to your other post) if
you know in advance the values that are acceptable (eg choose from a drop-down list of pre-defined values). Another approach could be to apply a User-defined function to the input, which strips out any unwanted characters. Hope this helps. Pete PaulinaDi wrote: What should I do to share a workbook but not accepting special characters on the different cells to be filled in? I'm refering to those characters like #$%& etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Name Ranges: Function to convert special characters underscores | Excel Worksheet Functions | |||
find special characters | Excel Discussion (Misc queries) | |||
Excel 'Special' Characters in Expressions | Excel Worksheet Functions | |||
Special Characters | Excel Discussion (Misc queries) | |||
Highlight special (dis-allowed) characters in a worksheet | Excel Discussion (Misc queries) |