On Jan 26, 12:13 pm, hoysala wrote:
Dear Dave,

i am am doing a poka yoka for my excel sheet.

we need to enter lot of data into that.

So double space means, is there a method to avoid double spacing
between to words.

like OLD MAN with single spacing and OLD MAN with double spacing ?

Please help me out

Could you use Custom Data Validation?

select the whole sheet then Data Validation|Allow: Custom and in the
Formula: box...

=NOT(COUNTIF(A1,"* *"))

Ken Johnson