Thread
:
Dataval question
View Single Post
#
1
Posted to microsoft.public.excel.programming
Steph[_3_]
external usenet poster
Posts: 312
Dataval question
I use the below formula in datavalidation to not allow commas in the cell.
Is there a way to add to this to also not allow more than 1 blank space in
the cell? Thank you!!
=IF(ISERROR(FIND(",",B5)),1,0)
Reply With Quote
Steph[_3_]
View Public Profile
Find all posts by Steph[_3_]