selecting data in a field between two points

[Guest]

I need two break up a large field into three smaller fields. I know I can
use commands like (right([field],30)) to get the first 30 characters and use
the left command to get the last 30 but is there a command to get between two
characters.
Something like (between([field],31,60))?
Thanks for your help!

 

[Rick B]

=Mid([SomeField],10,5)

will give you 5 digits starting at character 10.

Rick B