View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Character symbol meaning

In formulas, it represents to the operator to raise a value to a power:

=7^3
same as
=7*7*7
same as
343
--
Gary''s Student - gsnu200852


"Liz" wrote:

Hi -
Can someone tell me what the "^" symbol in the below variables is? Is this a
symbol for space or end of line?

lastw = .Substitute(str2, " ", "^", Len(str2) - Len(.Substitute(str2, " ",
"")))
lasti = .Find("^", lastw) + 1

Thanks,
Liz