In your case it is a text character....

In Ms Excel the 'Caret' operator is raise to the power of ....

=3^2

is 3 raised to the power of 2 which is 9


If this post helps click Yes
---------------
Jacob Skaria


"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