Forum Discussion

Derrick Peterson's avatar
Derrick Peterson
Copper Contributor
Oct 25, 2018

Access 2016 help: Separating out number for text.

I have a field in a table titled Description that has a mix of words and numbers.  The numbers can be found anyplace and combination with the text.  Is there a function or query that I can run to extract the numbers?

 

Example

  • Smith Pass 321 Regular
  • 73 Pass Smith
  • Express 89 Pass Porter

Thank you for your time and help!

No RepliesBe the first to reply

Resources