I use the below formula in data>validation 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)
I use the below formula in data>validation 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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks