How about event code that strips out all but numerics or alphas as you enter
data?

Private Sub Worksheet_Change(ByVal Target As Range)
Dim rCell As Range
Dim i As Long
Dim sChar As String
Dim sTemp As String
On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("A1:A10")) Is Nothing Then
With Target
For i = 1 To Len(.Text)
sChar = Mid(.Text, i, 1)
If sChar Like "[0-9a-zA-Z]" Then _
sTemp = sTemp & sChar
Next i
.Value = sTemp
End With
End If
ws_exit:
Application.EnableEvents = True
End Sub


Gord Dibben MS Excel MVP

On Mon, 30 Apr 2007 11:30:01 -0700, NLiles
wrote:

Is this something that cannot be done?.. I see lots of peoples questions
being answered but not mine :)..

Thanks


"NLiles" wrote:

I'm trying to create a template for users to enter data and have it input
onto a spreadsheet, there are some conditions i need to set using data
validation and im not sure how to do it.. There cannot be any
spaces,-,&,%,#... etc.. in the fields, but Numeric and Alpha are ok. There
also can only be 10 characters in the field which is easy to define. I tried
using the custom validation but I’m not familiar with how to create a formula
to achieve this goal.