String query

[morrisgr]

Hi.
This must be so easy for you guys and gals

I tried using...........

Findstring = "GUESTCharlieBrown"
LeftString = Left(Findstring, 5)
GuestString = Findstring - LeftString
..........should have produced "CharlieBrown"

What's wrong?
Findstring is OK as "GUESTCharlieBrown"
LeftString is OK as "GUEST"
But "GuestString" causes an error

I get "Type mismatch"

I have a lot of names with the prefix "GUEST" of varying lengths, so can't use "RightString"

Help much appreciated.
Rgds
Morris

 

[Marcelo Branco]

Try

Findstring = "GUESTCharlieBrown"
GuestString = Mid(Findstring, 6)

M.

 

[morrisgr]

Many thanks Marcelo...…..works perfectly.
Gracias from sunny Spain
Morris

Try

Findstring = "GUESTCharlieBrown"
GuestString = Mid(Findstring, 6)

M.

 

[Marcelo Branco]

Many thanks Marcelo...…..works perfectly.
Gracias from sunny Spain
Morris

You are very welcome. Glad to help

M.