Splitting a data field

B

Big Dog

I have a 5-character data field that I would like to split into a filed
containing characters 1 and 2, and a second field containing characters 3
thru 5. Can't figure it out - help greatly appreciated.
 
K

Klatuu

You can use 2 calculated field to do this.

FirstPart: Left([SomeField],2)
LastPart: Right([SomeField],3)
 
Top