need 3rd and 4th values from 7 digit text

R

Ray

Column 1 contains routing numbers (ie-RA12345). I need Column 2 to contain
the 3rd and 4th digit from column 1.

ex- Col1 Col2
RA12345 12
RW54321 54
RX98765 98

Can you please help?
 
D

David S via AccessMonster.com

You should be able to get them using the string function:
MID ([Column 1], 3, 2)
 
Top