Hi Paul,
I don't wanna copy the formula, just wanna copy the text after "=".
Sometimes there is a long string after "=", and I wanna copy that string
instead of typing it at other place:) If there is not shortcut, is there
any way at all..hehe
Well, regarding Ctrl+D : If there is formula in the above cell, actually
when you use Ctrl+D, the below cell copies the formula as well. That is
totally same as Ctrl+C then Ctrl+V...I don't know what makes Ctrl+D
different?
On Tue, May 12, 2009 at 2:20 PM, Paul Schreiner <schreiner_p...@att.net>wrote:
> Are you saying that you want to copy the formula WITHOUT the "=" ??
>
> I'm not sure if there is a shortcut.
>
> But in answer to your second question:
> Ctrl-D simply copies the contents of the above cell.
> Paul
>
> ------------------------------
> *From:* Yu <vincent2...@gmail.com>
> *To:* MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
> *Sent:* Tuesday, May 12, 2009 2:32:06 AM
> *Subject:* $$Excel-Macros$$ copy text from a formula & Ctrl+D
>
>
> Hi All,
>
>
> In cell A1 I have a formula like "=blablabla(arg1,arg2)". How
> can just copy "blablabla(arg1,arg2)" ? is there a short cut ?
>
> And what is the difference between Ctrl+D and "Ctrl+C then Ctrl
> +V"..both seem to copy and paste...and I was told there is slight
> differenct...
>
> Thanks!
>
> Yu
>
>
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
