How do I extract information, contained within parentheses, from a string?
Washer (12345) Steel = 12345
Carbon Filter (12H56-001) = 12H56-001
Right Wing 57 (HH12-P) = HH12-P
(1154489993) Camera = 1154489993
Last edited by stevemyers; 03-18-2010 at 03:36 PM.
Hi,
Try this:
Cheers,Code:=MID(A2,SEARCH("(",A2)+1,SEARCH(")",A2)-SEARCH("(",A2)-1)
Docendo discimus.
Please consider:
- Thanking those who helped you. Click the reputation icon
in the contributor's post and add Reputation.
- Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Thanks. Perfect
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks