extract number in string between parentheses

Status
Not open for further replies.

deb

Active Member
Joined
Feb 1, 2003
Messages
392
In access office 365

In a query...
I have a field with a string that varies in length, where the end is always a number between parentheses.

example
walk to work (4)
eat a salad with water (7)

How can I extract the number between the parentheses using a query.
4
7

Thank in advance
 
Last edited:

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,129
Office Version
365
Platform
Windows
Status
Not open for further replies.

Forum statistics

Threads
1,077,738
Messages
5,335,926
Members
399,058
Latest member
elada31

Some videos you may like

This Week's Hot Topics

Top