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.
|