No double space

[hoysala]

Hi all

Can any one guide me with a code which will NOT alllow DOUBLE SPACING
in the work sheet ?


hoysala

 

[DomThePom]

Please explain what you mean by double-spacing

 

[hoysala]

Hi all

Can any one guide me with a code which will NOT alllow DOUBLE SPACING
in the work sheet ?

hoysala

anyone there to help me ?

 

[Dave Peterson]

Only if you answer that question that DomThePom asked.

 

[hoysala]

Dear Dave,


i did not get you, can you please tell me what u mean by that?

 

[Dave Peterson]

You had a response that asked this:

Please explain what you mean by double-spacing

about 2 hours after your initial post.

 

[hoysala]

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

 

[Ken Johnson]

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

 

[Dave Peterson]

If your words/phrases are in a single column, you could use a formula to clean
up any mistakes:

If the words are in column A, you could insert a new column B and put this in
B1:

=trim(a1)
Then drag down as far as you need.

Then select column B
Edit|copy

Select column A
edit|paste special|values

And delete column B

 

[hoysala]

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

thnx ken

 

[Ken Johnson]

thnx ken

You're welcome, thanks for the feedback.

Ken Johnson