paste from clipboard issue

[Guest]

Hello guys,

I am encountering a really strange issue with standard paste in excel. Here
is what I do and the strange behavior I observe:
- I copy from excel a single line containing some blanks inside
- I open notepad and paste the line into it
- Then I copy the just pasted line from notepad and paste it into excel
- Magic, the blanks disapeared.

This is absolutely not what was expected, where is the setting to force exel
take into account the blank fields when pasting from the clipboard.

Thanks for your help.

 

[Guest]

Hi Pierre
I just tried it and it copied bach perfectly!

Peter

 

[Guest]

Hi Pierre,

yes you are right, on some configuration it works, and on the others it does
not. I have here two different PCs running the same version of excel and the
same OS, one behaves perfectly and the other has the behavior I described.
There is most probably a setting somewhere in excel and I would like to know
where ?
Any idea ?

Thanks

 

[Dave Peterson]

Excel will remember the last settings you used when you ran data|text to columns
(or file|open and go through the text import wizard). Excel will forget those
settings if you close and reopen excel.

Could it be that on one pc, there was an intermediate data|text to columns that
treated the space character as the field separator?

I'd close excel and reopen (on both machines) and then try the same steps for
the next test.

 

[Guest]

Hi Dave,

well I did what you said, and unfortunately it still the same behavior. I
even restarted both machines without success.

Concerning your question on an intermediate data|text to columns, well I
really do not know. How can I check this ? Do you have an idea ?

Thanks for your help.

Pierre

 

[Dave Peterson]

If you didn't use Data|text to columns or file|Open (and see the data import
wizard), then don't worry about that.

One more guess (and it's still a guess):

What is the windows list separator on each pc?

Under the control panel, windows regional and language options, regional options
tab, customize button, numbers tab.

Maybe there's a difference that causes a difference????