View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steph[_3_] Steph[_3_] is offline
external usenet poster
 
Posts: 312
Default 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)