extract value

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

Guest

i need assistance extract the following

12345 from 3001-12345Y
6534 from 2007-6534Z

thank you
 
thank rick. but if I have a value 2007-653Z I am getting 653z. I am needing
just 653. the number of digits before the letter is variable.

Rick B said:
Mid([SomeFieldName],6,4)

--
Rick B



stevensZoe said:
i need assistance extract the following

12345 from 3001-12345Y
6534 from 2007-6534Z

thank you
Click to expand...
Click to expand...
 

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

extract value 4
extract value 4
How to lookup given value from a range (with upper with lower limit) 2
Access Query Expression - Extremely Urgent!!! 3
Make Table Query 1
Help stripping a zipcode 4
Excel Extract Text from decimal separated string 6
extract text between asterisks 1

Back
Top