Copy cell value to clipboard

**adj7388** · 11-08-2009, 09:17 AM

Hello folks,

I can't believe I cannot find a solution to this problem somewhere on the Internet, but alas. I want to do something very simple:

1. Copy to the clipboard the contents of a cell in Excel, formatted as Currency.
2. Alt-Tab to a web browser
3. Paste the value WITH NO FORMATTING into an edit control.

For example, I copy the value 25000 (formatted to look like $25,000 by Excel) to the clipboard, then when I paste it into the browser edit field it appears with the dollar sign, commas, and some spaces thrown in for good measure.

Is there no way to make Excel copy only the value to the Windows clipboard with no formatting?

Yes, I know about Paste Special for pasting without the formatting. But I want to paste in an app that knows nothing of Paste Special.

Thanks in advance
adj

**Norie** · 11-08-2009, 10:33 AM

Why do you want to paste this value into the other application?

Perhaps there's a different approach?

You mention a web browser, are you trying to get information from the web?

If you are why not try using a web query (Data>Get External Data...New Web Query...

Or perhaps you could automate Internet Explorer using VBA.

**shg** · 11-08-2009, 11:54 AM

Select the cell and run this (to which you can assign a shortcut):

Please Login or Register  to view this content.

Then switch to any other application and paste (Ctrl+v).

**adj7388** · 11-08-2009, 01:52 PM

shg,

Many thanks. Your macro does just what I need. I figured it would involve VBA somehow, but was hoping to get it done without it. Oh, well.

Norie: Thanks for the reply, but I'm taking bits of data out of Excel and into a web app. So I don't need a web query.

Regards,
adj

**Cheeky Charlie** · 11-08-2009, 06:24 PM

Pah, too clever for me

F2, shift+home
Ctrl+c

Perhaps only comfortable for those who naviagate almost entirely by keyboard

**ImpetuousRacer** · 02-06-2013, 06:30 PM

Originally Posted by shg

Select the cell and run this (to which you can assign a shortcut):

Please Login or Register  to view this content.

Then switch to any other application and paste (Ctrl+v).

I was using this in Office 2010 x64 perfectly. Upgraded to Office 2013 x64. Opened the same spreadsheet, and now when I go to paste, it pastes 2 boxes instead of any text. If I paste into Excel, it pastes 2 boxes with question marks inside them. I checked and made sure the Object Form 2.0 was installed and it is. Do you know if they changed anything? Or what I would need to modify? Thanks for the help!

Also found this info:
"When I use this in Excel Office 2013 the data isn't in the clipboard and therefore I can't paste it. This never happened in prior versions.

Under closer inspection I've found that the string does go to the clipboard but as "System String" but not as "Text" or "Unicode Text".

BUT... about 10% of the time it acutally works as it should putting the string into the clipboard as "Text"."

**MartyExcel** · 12-03-2013, 11:54 PM

shg,

That's GREAT!

How would you do it for multiple cells or range?

Thanks

**EagleEyes** · 03-23-2019, 12:32 AM

I tried your suggestion, but it places an apostrophe before the text in the cell. It was closer than nothing. I was wanting to past into a "Save As" Filename field via a Macro, and could not get clean cell contents. Initially got nothing, then your suggestion gives me an apostrophe plus everything I wanted

**JeteMc** · 03-25-2019, 11:45 AM

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread