Access 2016 help: Separating out number for text.

Copper Contributor

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!

0 Replies