Hi all

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


hoysala

Please explain what you mean by double-spacing

"hoysala" wrote:


Hi all

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


hoysala

On Jan 25, 11:50*am, hoysala wrote:
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 ?

Only if you answer that question that DomThePom asked.

hoysala wrote:

On Jan 25, 11:50 am, hoysala wrote:
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

Dear Dave,


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

You had a response that asked this:

Please explain what you mean by double-spacing

about 2 hours after your initial post.

hoysala wrote:

Dear Dave,

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

--

Dave Peterson

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

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

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 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

--

Dave Peterson

On Jan 26, 7:45*am, Ken Johnson wrote:
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

thnx ken

On Jan 27, 3:39 pm, hoysala wrote:
On Jan 26, 7:45 am, Ken Johnson wrote:



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

thnx ken

You're welcome, thanks for the feedback.

Ken Johnson