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
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 editreplace operation.

EditReplace

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
wrote:



On Nov 30, 12:38*pm, Daryl S 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 -