Forum Discussion
Derrick Peterson
Oct 25, 2018Copper Contributor
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