Copy contents of a cell without formatting or control charcs

[aparna]

Every time I copy the contents of an excel cell it copies the text box and some formating characters alongwith the contents.

Is there anyway I can copy the contents of a cell as pure text either through a macro or VBA.

 

[Peter_SSs]

Re: Copy contents of a cell without formatting or control ch

Every time I copy the contents of an excel cell it copies the text box and some formating characters alongwith the contents.

Is there anyway I can copy the contents of a cell as pure text either through a macro or VBA.

What text box and formatting characters?

 

[al_b_cnu]

Hi,

Try Edit / Paste Special / Values

alternatively, to coopy A1 to B1 via VBA,

Range("B1).value=Rangre("A1").value

 

[aparna]

To test this, try copying any data from a cell in excel and paste this on Word.

You will find that alongwith the data you will find that a text box and a CRLF character is automatically pasted on word.

Aparna

 

[Peter_SSs]

To test this, try copying any data from a cell in excel and paste this on Word.

You will find that alongwith the data you will find that a text box and a CRLF character is automatically pasted on word.

Aparna

You didn't mention moving out of Excel and into Word before so it was no wonder nobody knew what you were asking.

I have Word 2002 and when I paste there from Excel, a small icon with 'Paste Options' appears near the pasted data. One of the options is 'Keep Text Only'. I think it should be pretty much what you want. If you have an older version of Office, you may not have this option.

 

[aparna]

Hi Alan,
Thanks so much for your reply. I realised that Edit Paste Special Value works only within Excel. I am looking at copying the contents in another application eg Word or SAP etc.
Aparna