what does the "carat" character mean in Excel - answer

  • Follow


Jackson -

I can't reply to your posting directly - I suspect the "^" character in your 
posting subject may be the culprit. 

To answer your question, the carat represents a 'to the power of' operation. 
 That is x^2 means x squared (x times itself).   y^3 means y cubed (y times y 
times y).

Hope that helps!

-- 
Daryl S
0
Reply Utf 11/30/2009 5:38:02 PM

Daryl,

it's probably something to do with the browser that you use to access
the newsgroups. If a poster does not expand on his heading for the
thread and use the message body, then some browsers do not allow you
to respond to it.

Hope this helps.

Pete

On Nov 30, 5:38=A0pm, Daryl S <Dar...@discussions.microsoft.com> wrote:
> Jackson -
>
> I can't reply to your posting directly - I suspect the "^" character in y=
our
> posting subject may be the culprit.
>
> To answer your question, the carat represents a 'to the power of' operati=
on.
> =A0That is x^2 means x squared (x times itself). =A0 y^3 means y cubed (y=
 times y
> times y).
>
> Hope that helps!
>
> --
> Daryl S

0
Reply Pete_UK 11/30/2009 5:45:51 PM


Daryl,
You are correct but need to add that ^ is called the exponentiation operator
best wishes
-- 
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"Daryl S" <DarylS@discussions.microsoft.com> wrote in message 
news:B12B8965-9620-4005-B039-E7CDD4E1563A@microsoft.com...
> Jackson -
>
> I can't reply to your posting directly - I suspect the "^" character in 
> your
> posting subject may be the culprit.
>
> To answer your question, the carat represents a 'to the power of' 
> operation.
> That is x^2 means x squared (x times itself).   y^3 means y cubed (y times 
> y
> times y).
>
> Hope that helps!
>
> -- 
> Daryl S 

0
Reply Bernard 11/30/2009 7:42:14 PM

One would think it would be a simple matter to have some sort of check to 
make sure a poster puts something in the body of the message, or have it 
default to "no text"...

Until then, we can only hope people will one day learn the difference 
between "subject" and "message".
-- 
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Pete_UK" wrote:

> Daryl,
> 
> it's probably something to do with the browser that you use to access
> the newsgroups. If a poster does not expand on his heading for the
> thread and use the message body, then some browsers do not allow you
> to respond to it.
> 
> Hope this helps.
> 
> Pete
> 
> On Nov 30, 5:38 pm, Daryl S <Dar...@discussions.microsoft.com> wrote:
> > Jackson -
> >
> > I can't reply to your posting directly - I suspect the "^" character in your
> > posting subject may be the culprit.
> >
> > To answer your question, the carat represents a 'to the power of' operation.
> >  That is x^2 means x squared (x times itself).   y^3 means y cubed (y times y
> > times y).
> >
> > Hope that helps!
> >
> > --
> > Daryl S
> 
> .
> 
0
Reply Utf 11/30/2009 7:49:01 PM

"Pete_UK" <pashurst@auditel.net> wrote:
> it's probably something to do with the browser
> that you use to access the newsgroups.

Hmm, I always thought it was simply yet-another thing that is wrong with the 
MS Discussion Groups web interface, independent of the browser.

For example, using IE6 to respond to the original subject-only posting via 
MSDG and Google Groups, I have no problem creating a response using GG.  It 
is only MSDG that fails.

I am unable to test my theory using Firefox because I cannot even log into 
MSDG using FF.

(That might be an intermittent problem with the MSDG service.  Now, I am 
getting Service Unavailable errors with both IE6 and FF.)


----- original message -----


"Pete_UK" <pashurst@auditel.net> wrote in message 
news:a0290311-07b4-42ec-a38c-86857b869ae2@u20g2000vbq.googlegroups.com...
Daryl,

it's probably something to do with the browser that you use to access
the newsgroups. If a poster does not expand on his heading for the
thread and use the message body, then some browsers do not allow you
to respond to it.

Hope this helps.

Pete

On Nov 30, 5:38 pm, Daryl S <Dar...@discussions.microsoft.com> wrote:
> Jackson -
>
> I can't reply to your posting directly - I suspect the "^" character in 
> your
> posting subject may be the culprit.
>
> To answer your question, the carat represents a 'to the power of' 
> operation.
> That is x^2 means x squared (x times itself). y^3 means y cubed (y times y
> times y).
>
> Hope that helps!
>
> --
> Daryl S

0
Reply Joe 12/1/2009 12:05:23 AM

On Nov 30, 12:38=A0pm, Daryl S <Dar...@discussions.microsoft.com> wrote:
> Jackson -
>
> I can't reply to your posting directly - I suspect the "^" character in y=
our
> posting subject may be the culprit.
>
> To answer your question, the carat represents a 'to the power of' operati=
on.
> =A0That is x^2 means x squared (x times itself). =A0 y^3 means y cubed (y=
 times y
> times y).
>
> Hope that helps!
>
> --
> Daryl S

Hi All! I'm read thru the thread here and still don't quite understand
the double carat use of "^^".

Please advise.
Thanks, Matty
0
Reply fullgale1 12/21/2009 6:16:01 PM

Double caret ^^ does nothing.

=2^^3   throws an error.

Maybe you meant to type  =2^3^4  which is same as  =2^12

Where have you seen a double caret ^^ used?

I sometimes use ^^ in an edit>replace operation.

Edit>Replace

What:  =

With:  ^^

Replace all.

I will do this when I want to copy linked formulas from one workbook to
another without creating a link to source workbook.


Gord Dibben  MS Excel MVP

On Mon, 21 Dec 2009 10:16:01 -0800 (PST), fullgale1 <fullgale1@gmail.com>
wrote:

>On Nov 30, 12:38�pm, Daryl S <Dar...@discussions.microsoft.com> wrote:
>> Jackson -
>>
>> I can't reply to your posting directly - I suspect the "^" character in your
>> posting subject may be the culprit.
>>
>> To answer your question, the carat represents a 'to the power of' operation.
>> �That is x^2 means x squared (x times itself). � y^3 means y cubed (y times y
>> times y).
>>
>> Hope that helps!
>>
>> --
>> Daryl S
>
>Hi All! I'm read thru the thread here and still don't quite understand
>the double carat use of "^^".
>
>Please advise.
>Thanks, Matty

0
Reply Gord 12/21/2009 7:47:56 PM

Hi Gord,

I saw a post the other day where someone was suggesting a formula
using SUBSTITUTE to replace a space with 2 carets - presumably because
this is a character sequence that one would not normally encounter -
similar to your Find & replace example. Maybe fullgale1 saw that same
post.

Pete

On Dec 21, 7:47=A0pm, Gord Dibben <gorddibbATshawDOTca> wrote:
> Double caret ^^ does nothing.
>
> =3D2^^3 =A0 throws an error.
>
> Maybe you meant to type =A0=3D2^3^4 =A0which is same as =A0=3D2^12
>
> Where have you seen a double caret ^^ used?
>
> I sometimes use ^^ in an edit>replace operation.
>
> Edit>Replace
>
> What: =A0=3D
>
> With: =A0^^
>
> Replace all.
>
> I will do this when I want to copy linked formulas from one workbook to
> another without creating a link to source workbook.
>
> Gord Dibben =A0MS Excel MVP
>
> On Mon, 21 Dec 2009 10:16:01 -0800 (PST), fullgale1 <fullga...@gmail.com>
> wrote:
>
>
>
> >On Nov 30, 12:38=A0pm, Daryl S <Dar...@discussions.microsoft.com> wrote:
> >> Jackson -
>
> >> I can't reply to your posting directly - I suspect the "^" character i=
n your
> >> posting subject may be the culprit.
>
> >> To answer your question, the carat represents a 'to the power of' oper=
ation.
> >> =A0That is x^2 means x squared (x times itself). =A0 y^3 means y cubed=
 (y times y
> >> times y).
>
> >> Hope that helps!
>
> >> --
> >> Daryl S
>
> >Hi All! I'm read thru the thread here and still don't quite understand
> >the double carat use of "^^".
>
> >Please advise.
> >Thanks, Matty- Hide quoted text -
>
> - Show quoted text -

0
Reply Pete_UK 12/22/2009 1:17:45 AM

Very true............I have seen that particular ^^ used with the SUBSTITUTE
function.


Gord


On Mon, 21 Dec 2009 17:17:45 -0800 (PST), Pete_UK <pashurst@auditel.net>
wrote:

>Hi Gord,
>
>I saw a post the other day where someone was suggesting a formula
>using SUBSTITUTE to replace a space with 2 carets - presumably because
>this is a character sequence that one would not normally encounter -
>similar to your Find & replace example. Maybe fullgale1 saw that same
>post.
>
>Pete
>
>On Dec 21, 7:47�pm, Gord Dibben <gorddibbATshawDOTca> wrote:
>> Double caret ^^ does nothing.
>>
>> =2^^3 � throws an error.
>>
>> Maybe you meant to type �=2^3^4 �which is same as �=2^12
>>
>> Where have you seen a double caret ^^ used?
>>
>> I sometimes use ^^ in an edit>replace operation.
>>
>> Edit>Replace
>>
>> What: �=
>>
>> With: �^^
>>
>> Replace all.
>>
>> I will do this when I want to copy linked formulas from one workbook to
>> another without creating a link to source workbook.
>>
>> Gord Dibben �MS Excel MVP
>>
>> On Mon, 21 Dec 2009 10:16:01 -0800 (PST), fullgale1 <fullga...@gmail.com>
>> wrote:
>>
>>
>>
>> >On Nov 30, 12:38�pm, Daryl S <Dar...@discussions.microsoft.com> wrote:
>> >> Jackson -
>>
>> >> I can't reply to your posting directly - I suspect the "^" character in your
>> >> posting subject may be the culprit.
>>
>> >> To answer your question, the carat represents a 'to the power of' operation.
>> >> �That is x^2 means x squared (x times itself). � y^3 means y cubed (y times y
>> >> times y).
>>
>> >> Hope that helps!
>>
>> >> --
>> >> Daryl S
>>
>> >Hi All! I'm read thru the thread here and still don't quite understand
>> >the double carat use of "^^".
>>
>> >Please advise.
>> >Thanks, Matty- Hide quoted text -
>>
>> - Show quoted text -

0
Reply Gord 12/22/2009 1:41:28 AM

8 Replies
258 Views

(page loaded in 0.16 seconds)

Similiar Articles:
















7/11/2012 2:48:15 PM


Reply: