no probs .. all have days like that :)

--
Cheers
JulieD

"Mark" wrote in message
...
you're correct..it does work.. i'm brain dead this morning..
sorry for wasting your time. (my error was related to something else)
thx.


"JulieD" wrote in message
...
Hi Mark

umm, left should work .. check out the following


Sub teststring()
mystr = "abc"
MsgBox Left(mystr, 2)
End Sub

if you can't get it to work, post your code and we'll have a look.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway
"Mark" wrote in message
...
i'm writing a macro from within excel 2003. if i have a string with
value
"abc", how do i select just "ab".

i tried the left(string,number) function (which i use in VB all the
time)
but i guess within excel that doesnt' work?

thanks.