Calculation Needed to Remove Text from Field

[bonngo]

I have a field that has 2-3 characters followed by a hypen that I need to remove. The result needs to be the remaining text. The problem for me is because of the varying number of characters.

For ex: V1-John Smith

I want returned as: John Smith

and V25-Bill Jones returned as: Bill Jones

Thanks in advance for any help.

[comment]

Try

Right ( text ; Length ( text ) - Position ( text ; "-" ; 1 ; 1 ) )

[bonngo]

BEAUTIFUL!

THANK YOU VERY MUCH!

[Fitch]

Here's the same thing written slightly differently:

Let ( 

  [ name = your::field ; 

    dash = Position ( name ; "-" ; 1 ; 1 ) ; 

    chars = Length ( name ) - dash ] ;

  Right ( name ; chars )

 )

[Fitch]

Man, I just can't post fast enough today!

[Lee Smith]

I know what you mean, I posted the same calculation as comment, only to discover he had beat me by a few seconds. Oh well, I probably stole it from him in the first place. LOL

Lee