need 3rd and 4th values from 7 digit text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You should be able to get them using the string function:
MID ([Column 1], 3, 2)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query the brings only 0 value 5
Help with count query 4
Help with crosstab query 1
Checking if data exists another table and, if yes, extracting a value 0
Serial No for Unique Value 1
Divide Max of one column with value in current record 1
query criteria based on 2 cell values in diffrent rows 1
Help with Query 4

Back
Top