how to get formula content of a cell?

[muster]

For example

A1: =b2+c2, result is 5

I'd like to get "=b2+c2", not 5, without VBA.

Thank you.

[Alan]

Press Ctrl and ` together (key to the left of 1 on the left side of the
keyboard),
Regards,
Alan.

"muster" <muster@gmail.com> wrote in message
news:1154097299.254532.111380@i3g2000cwc.googlegroups.com...
> For example
>
> A1: =b2+c2, result is 5
>
> I'd like to get "=b2+c2", not 5, without VBA.
>
> Thank you.
>

[David Biddulph]

"muster" <muster@gmail.com> wrote in message
news:1154097299.254532.111380@i3g2000cwc.googlegroups.com...
> For example
>
> A1: =b2+c2, result is 5
>
> I'd like to get "=b2+c2", not 5, without VBA.

Tools/ Options/ View: Formulas
--
David Biddulph

[muster]

Thank you. What I really want is to reference to the formula in another
cell.

Alan wrote:
> Press Ctrl and ` together (key to the left of 1 on the left side of the
> keyboard),
> Regards,
> Alan.
>
> "muster" <muster@gmail.com> wrote in message
> news:1154097299.254532.111380@i3g2000cwc.googlegroups.com...
> > For example
> >
> > A1: =b2+c2, result is 5
> >
> > I'd like to get "=b2+c2", not 5, without VBA.
> >
> > Thank you.
> >

[Kevin Vaughn]

I interpreted this differently than the other 2 responders to your question.
If my interpretation is correct, there is absolutely no way (that I know of)
to get the formula contents of a cell (returned into another cell; this is
where my interpretation differs,) without using VBA.

I qualified my answer to include the phrase that I know of just in case.
Due to the slight possibility that someone will pipe up with an answer that I
never heard of. But if such a solution exists, I wonder why I haven't heard
of it before.
--
Kevin Vaughn


"muster" wrote:

> For example
>
> A1: =b2+c2, result is 5
>
> I'd like to get "=b2+c2", not 5, without VBA.
>
> Thank you.
>
>

[Kevin Vaughn]

I interpreted this differently than the other 2 responders to your question.
If my interpretation is correct, there is absolutely no way (that I know of)
to get the formula contents of a cell (returned into another cell; this is
where my interpretation differs,) without using VBA.

I qualified my answer to include the phrase that I know of just in case.
Due to the slight possibility that someone will pipe up with an answer that I
never heard of. But if such a solution exists, I wonder why I haven't heard
of it before.
--
Kevin Vaughn


"muster" wrote:

> For example
>
> A1: =b2+c2, result is 5
>
> I'd like to get "=b2+c2", not 5, without VBA.
>
> Thank you.
>
>

[muster]

You interpret right. That's why I ask in worksheetfunctions group.
Thank you.

Kevin Vaughn wrote:
> I interpreted this differently than the other 2 responders to your question.
> If my interpretation is correct, there is absolutely no way (that I know of)
> to get the formula contents of a cell (returned into another cell; this is
> where my interpretation differs,) without using VBA.
>
> I qualified my answer to include the phrase that I know of just in case.
> Due to the slight possibility that someone will pipe up with an answer that I
> never heard of. But if such a solution exists, I wonder why I haven't heard
> of it before.
> --
> Kevin Vaughn
>
>
> "muster" wrote:
>
> > For example
> >
> > A1: =b2+c2, result is 5
> >
> > I'd like to get "=b2+c2", not 5, without VBA.
> >
> > Thank you.
> >
> >

[Beege]

Muster,

I know you said "no VBA", but this might help to address your question:

http://www.mvps.org/dmcritchie/excel/formula.htm

Beege

"muster" <muster@gmail.com> wrote in message
news:1154097299.254532.111380@i3g2000cwc.googlegroups.com...
> For example
>
> A1: =b2+c2, result is 5
>
> I'd like to get "=b2+c2", not 5, without VBA.
>
> Thank you.
>

[Beege]

Muster,

Found this, too... and no VBA

http://www.mcse.ms/archive144-2005-5-1637686.html

Beege

"muster" <muster@gmail.com> wrote in message
news:1154097299.254532.111380@i3g2000cwc.googlegroups.com...
> For example
>
> A1: =b2+c2, result is 5
>
> I'd like to get "=b2+c2", not 5, without VBA.
>
> Thank you.
>

[muster]

Thank you.

Beege wrote:
> Muster,
>
> Found this, too... and no VBA
>
> http://www.mcse.ms/archive144-2005-5-1637686.html
>
> Beege
>
> "muster" <muster@gmail.com> wrote in message
> news:1154097299.254532.111380@i3g2000cwc.googlegroups.com...
> > For example
> >
> > A1: =b2+c2, result is 5
> >
> > I'd like to get "=b2+c2", not 5, without VBA.
> >
> > Thank you.
> >

[Beege]

muster,

you/re welcome...

Beege


"muster" <muster@gmail.com> wrote in message
news:1154112658.669757.153500@p79g2000cwp.googlegroups.com...
> Thank you.
>
> Beege wrote:
>> Muster,
>>
>> Found this, too... and no VBA
>>
>> http://www.mcse.ms/archive144-2005-5-1637686.html
>>
>> Beege
>>
>> "muster" <muster@gmail.com> wrote in message
>> news:1154097299.254532.111380@i3g2000cwc.googlegroups.com...
>> > For example
>> >
>> > A1: =b2+c2, result is 5
>> >
>> > I'd like to get "=b2+c2", not 5, without VBA.
>> >
>> > Thank you.
>> >
>

[Kevin Vaughn]

I'm glad I qualified my answer. However, I believe that there is a potential
problem with this solution. I tested it and it did work, however, this is
probably a function leftover from Excel's previous macro language (the name
of which escapes me, something like xmla,) which I have read can cause (I
believe) a crash if copied to other worksheets in certain versions of Excel
(something like that.) If someone reads this and knows the exact scenario,
hopefully they'll respond with the specifics.
--
Kevin Vaughn


"Beege" wrote:

> Muster,
>
> Found this, too... and no VBA
>
> http://www.mcse.ms/archive144-2005-5-1637686.html
>
> Beege
>
> "muster" <muster@gmail.com> wrote in message
> news:1154097299.254532.111380@i3g2000cwc.googlegroups.com...
> > For example
> >
> > A1: =b2+c2, result is 5
> >
> > I'd like to get "=b2+c2", not 5, without VBA.
> >
> > Thank you.
> >
>
>
>

[Ragdyer]

From XL02 forward, the bug was fixed.

I've used it in past versions, although not on any WB that was put on the
LAN.

Can never trust users to listen to, and follow instructions, especially
pertaining to fatal consequences.

In fact, I've suggested it's use in a post just today, but prefixed it with
the caveat of pre-XL02 usage.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Kevin Vaughn" <KevinVaughn@discussions.microsoft.com> wrote in message
news:B3EA28EA-575F-4382-8FC9-284866562960@microsoft.com...
> I'm glad I qualified my answer. However, I believe that there is a
> potential
> problem with this solution. I tested it and it did work, however, this is
> probably a function leftover from Excel's previous macro language (the
> name
> of which escapes me, something like xmla,) which I have read can cause (I
> believe) a crash if copied to other worksheets in certain versions of
> Excel
> (something like that.) If someone reads this and knows the exact
> scenario,
> hopefully they'll respond with the specifics.
> --
> Kevin Vaughn
>
>
> "Beege" wrote:
>
>> Muster,
>>
>> Found this, too... and no VBA
>>
>> http://www.mcse.ms/archive144-2005-5-1637686.html
>>
>> Beege
>>
>> "muster" <muster@gmail.com> wrote in message
>> news:1154097299.254532.111380@i3g2000cwc.googlegroups.com...
>> > For example
>> >
>> > A1: =b2+c2, result is 5
>> >
>> > I'd like to get "=b2+c2", not 5, without VBA.
>> >
>> > Thank you.
>> >
>>
>>
>>

[Peo Sjoblom]

The bug was fixed so it wouldn't crash but I believe you can't copy the
formula to another sheet


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com


"Ragdyer" <RagDyer@cutoutmsn.com> wrote in message
news:eKDIA9osGHA.3324@TK2MSFTNGP04.phx.gbl...
> From XL02 forward, the bug was fixed.
>
> I've used it in past versions, although not on any WB that was put on the
> LAN.
>
> Can never trust users to listen to, and follow instructions, especially
> pertaining to fatal consequences.
>
> In fact, I've suggested it's use in a post just today, but prefixed it
> with the caveat of pre-XL02 usage.
> --
> Regards,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Kevin Vaughn" <KevinVaughn@discussions.microsoft.com> wrote in message
> news:B3EA28EA-575F-4382-8FC9-284866562960@microsoft.com...
>> I'm glad I qualified my answer. However, I believe that there is a
>> potential
>> problem with this solution. I tested it and it did work, however, this
>> is
>> probably a function leftover from Excel's previous macro language (the
>> name
>> of which escapes me, something like xmla,) which I have read can cause (I
>> believe) a crash if copied to other worksheets in certain versions of
>> Excel
>> (something like that.) If someone reads this and knows the exact
>> scenario,
>> hopefully they'll respond with the specifics.
>> --
>> Kevin Vaughn
>>
>>
>> "Beege" wrote:
>>
>>> Muster,
>>>
>>> Found this, too... and no VBA
>>>
>>> http://www.mcse.ms/archive144-2005-5-1637686.html
>>>
>>> Beege
>>>
>>> "muster" <muster@gmail.com> wrote in message
>>> news:1154097299.254532.111380@i3g2000cwc.googlegroups.com...
>>> > For example
>>> >
>>> > A1: =b2+c2, result is 5
>>> >
>>> > I'd like to get "=b2+c2", not 5, without VBA.
>>> >
>>> > Thank you.
>>> >
>>>
>>>
>>>
>

[Kevin Vaughn]

Thanks. So I would still be affected as I am still using 2000.
--
Kevin Vaughn


"Ragdyer" wrote:

> From XL02 forward, the bug was fixed.
>
> I've used it in past versions, although not on any WB that was put on the
> LAN.
>
> Can never trust users to listen to, and follow instructions, especially
> pertaining to fatal consequences.
>
> In fact, I've suggested it's use in a post just today, but prefixed it with
> the caveat of pre-XL02 usage.
> --
> Regards,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Kevin Vaughn" <KevinVaughn@discussions.microsoft.com> wrote in message
> news:B3EA28EA-575F-4382-8FC9-284866562960@microsoft.com...
> > I'm glad I qualified my answer. However, I believe that there is a
> > potential
> > problem with this solution. I tested it and it did work, however, this is
> > probably a function leftover from Excel's previous macro language (the
> > name
> > of which escapes me, something like xmla,) which I have read can cause (I
> > believe) a crash if copied to other worksheets in certain versions of
> > Excel
> > (something like that.) If someone reads this and knows the exact
> > scenario,
> > hopefully they'll respond with the specifics.
> > --
> > Kevin Vaughn
> >
> >
> > "Beege" wrote:
> >
> >> Muster,
> >>
> >> Found this, too... and no VBA
> >>
> >> http://www.mcse.ms/archive144-2005-5-1637686.html
> >>
> >> Beege
> >>
> >> "muster" <muster@gmail.com> wrote in message
> >> news:1154097299.254532.111380@i3g2000cwc.googlegroups.com...
> >> > For example
> >> >
> >> > A1: =b2+c2, result is 5
> >> >
> >> > I'd like to get "=b2+c2", not 5, without VBA.
> >> >
> >> > Thank you.
> >> >
> >>
> >>
> >>
>
>

[RagDyeR]

AFAIK Peo, *everything* was fixed!

Copying from WB to WB is no longer a problem.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Peo Sjoblom" <peo.sjoblom@nw^^excelsolutions.com> wrote in message
news:%23l9miOpsGHA.4324@TK2MSFTNGP05.phx.gbl...
The bug was fixed so it wouldn't crash but I believe you can't copy the
formula to another sheet


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com


"Ragdyer" <RagDyer@cutoutmsn.com> wrote in message
news:eKDIA9osGHA.3324@TK2MSFTNGP04.phx.gbl...
> From XL02 forward, the bug was fixed.
>
> I've used it in past versions, although not on any WB that was put on the
> LAN.
>
> Can never trust users to listen to, and follow instructions, especially
> pertaining to fatal consequences.
>
> In fact, I've suggested it's use in a post just today, but prefixed it
> with the caveat of pre-XL02 usage.
> --
> Regards,
>
> RD
>
> --------------------------------------------------------------------------
-
> Please keep all correspondence within the NewsGroup, so all may benefit !
> --------------------------------------------------------------------------
-
> "Kevin Vaughn" <KevinVaughn@discussions.microsoft.com> wrote in message
> news:B3EA28EA-575F-4382-8FC9-284866562960@microsoft.com...
>> I'm glad I qualified my answer. However, I believe that there is a
>> potential
>> problem with this solution. I tested it and it did work, however, this
>> is
>> probably a function leftover from Excel's previous macro language (the
>> name
>> of which escapes me, something like xmla,) which I have read can cause (I
>> believe) a crash if copied to other worksheets in certain versions of
>> Excel
>> (something like that.) If someone reads this and knows the exact
>> scenario,
>> hopefully they'll respond with the specifics.
>> --
>> Kevin Vaughn
>>
>>
>> "Beege" wrote:
>>
>>> Muster,
>>>
>>> Found this, too... and no VBA
>>>
>>> http://www.mcse.ms/archive144-2005-5-1637686.html
>>>
>>> Beege
>>>
>>> "muster" <muster@gmail.com> wrote in message
>>> news:1154097299.254532.111380@i3g2000cwc.googlegroups.com...
>>> > For example
>>> >
>>> > A1: =b2+c2, result is 5
>>> >
>>> > I'd like to get "=b2+c2", not 5, without VBA.
>>> >
>>> > Thank you.
>>> >
>>>
>>>
>>>
>

[RagDyeR]

You would cause XL to crash *IF* you attempted to *COPY* the formula to
another WB.

Using it is *not* a problem.
Creating (re-writing) it in another WB is *not* a problem.

It has it's place when used properly in the pre-XL02 versions.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Kevin Vaughn" <KevinVaughn@discussions.microsoft.com> wrote in message
news:13B7DFFD-7D1F-4330-879C-F20A5C07AB7B@microsoft.com...
Thanks. So I would still be affected as I am still using 2000.
--
Kevin Vaughn


"Ragdyer" wrote:

> From XL02 forward, the bug was fixed.
>
> I've used it in past versions, although not on any WB that was put on the
> LAN.
>
> Can never trust users to listen to, and follow instructions, especially
> pertaining to fatal consequences.
>
> In fact, I've suggested it's use in a post just today, but prefixed it
with
> the caveat of pre-XL02 usage.
> --
> Regards,
>
> RD
>
> --------------------------------------------------------------------------
-
> Please keep all correspondence within the NewsGroup, so all may benefit !
> --------------------------------------------------------------------------
-
> "Kevin Vaughn" <KevinVaughn@discussions.microsoft.com> wrote in message
> news:B3EA28EA-575F-4382-8FC9-284866562960@microsoft.com...
> > I'm glad I qualified my answer. However, I believe that there is a
> > potential
> > problem with this solution. I tested it and it did work, however, this
is
> > probably a function leftover from Excel's previous macro language (the
> > name
> > of which escapes me, something like xmla,) which I have read can cause
(I
> > believe) a crash if copied to other worksheets in certain versions of
> > Excel
> > (something like that.) If someone reads this and knows the exact
> > scenario,
> > hopefully they'll respond with the specifics.
> > --
> > Kevin Vaughn
> >
> >
> > "Beege" wrote:
> >
> >> Muster,
> >>
> >> Found this, too... and no VBA
> >>
> >> http://www.mcse.ms/archive144-2005-5-1637686.html
> >>
> >> Beege
> >>
> >> "muster" <muster@gmail.com> wrote in message
> >> news:1154097299.254532.111380@i3g2000cwc.googlegroups.com...
> >> > For example
> >> >
> >> > A1: =b2+c2, result is 5
> >> >
> >> > I'd like to get "=b2+c2", not 5, without VBA.
> >> >
> >> > Thank you.
> >> >
> >>
> >>
> >>
>
>

[Kevin Vaughn]

Ah. It's copying to another workbook? For some reason, I was under the
impression that it was copying to another worksheet that was the problem.
Thanks. So far I haven't felt like testing it (to the extent of trying to
make Excel crash.)
--
Kevin Vaughn


"RagDyeR" wrote:

> You would cause XL to crash *IF* you attempted to *COPY* the formula to
> another WB.
>
> Using it is *not* a problem.
> Creating (re-writing) it in another WB is *not* a problem.
>
> It has it's place when used properly in the pre-XL02 versions.
> --
>
> Regards,
>
> RD
> ----------------------------------------------------------------------------
> -------------------
> Please keep all correspondence within the Group, so all may benefit !
> ----------------------------------------------------------------------------
> -------------------
>
> "Kevin Vaughn" <KevinVaughn@discussions.microsoft.com> wrote in message
> news:13B7DFFD-7D1F-4330-879C-F20A5C07AB7B@microsoft.com...
> Thanks. So I would still be affected as I am still using 2000.
> --
> Kevin Vaughn
>
>
> "Ragdyer" wrote:
>
> > From XL02 forward, the bug was fixed.
> >
> > I've used it in past versions, although not on any WB that was put on the
> > LAN.
> >
> > Can never trust users to listen to, and follow instructions, especially
> > pertaining to fatal consequences.
> >
> > In fact, I've suggested it's use in a post just today, but prefixed it
> with
> > the caveat of pre-XL02 usage.
> > --
> > Regards,
> >
> > RD
> >
> > --------------------------------------------------------------------------
> -
> > Please keep all correspondence within the NewsGroup, so all may benefit !
> > --------------------------------------------------------------------------
> -
> > "Kevin Vaughn" <KevinVaughn@discussions.microsoft.com> wrote in message
> > news:B3EA28EA-575F-4382-8FC9-284866562960@microsoft.com...
> > > I'm glad I qualified my answer. However, I believe that there is a
> > > potential
> > > problem with this solution. I tested it and it did work, however, this
> is
> > > probably a function leftover from Excel's previous macro language (the
> > > name
> > > of which escapes me, something like xmla,) which I have read can cause
> (I
> > > believe) a crash if copied to other worksheets in certain versions of
> > > Excel
> > > (something like that.) If someone reads this and knows the exact
> > > scenario,
> > > hopefully they'll respond with the specifics.
> > > --
> > > Kevin Vaughn
> > >
> > >
> > > "Beege" wrote:
> > >
> > >> Muster,
> > >>
> > >> Found this, too... and no VBA
> > >>
> > >> http://www.mcse.ms/archive144-2005-5-1637686.html
> > >>
> > >> Beege
> > >>
> > >> "muster" <muster@gmail.com> wrote in message
> > >> news:1154097299.254532.111380@i3g2000cwc.googlegroups.com...
> > >> > For example
> > >> >
> > >> > A1: =b2+c2, result is 5
> > >> >
> > >> > I'd like to get "=b2+c2", not 5, without VBA.
> > >> >
> > >> > Thank you.
> > >> >
> > >>
> > >>
> > >>
> >
> >
>
>
>