Copy cell value and delete white spaces?

Hi experts!

I made a little excel worksheet to make my daily work a little easier. (Excel 97)

Now I have a simple problem!

I have a macro applied to a button and when I click on it a cell is copied in the clipboard because I need the data in a different application. The date in the cell is variable and changes depending what I did before I hit the copy button.

That works great but when I paste the content from the clipboard in another application (ex. notepad) there are a lot of white spaces after the cell content. I need to delete this with spaces before I paste the value in the other application.

I tried a few times with "Trim" but with no success. I don't know much about macro programming.

To copy the cell with the macro, I select the cell and then I use the copy funtion.

How can I delete this white spaces?


Thank you so much!

Regards,
Michael

There is not a big thing to post.

Please Login or Register  to view this content.

That's what I use to get the value in my clipboard.

You could try to copy the cell to another blank cell somewhere out of sight, trim it there and then copy to the clipboard.

Why use a different cell? And how do I trim the content?

Could someone please help me out?


Regards,
Michael

To fill the cell I use different macros looking like that:

Please Login or Register  to view this content.

I did a test with Excel 2007 and there are no white spaces at the end of the content.
But I can only use Excel 97 at work. It's not possible to change that!

Any suggestions?

please could anybody give me a hint.

It was a merged cell! That caused the problem!