Extract

Bo · Nov 10, 2003

How do I extract part of a text string such as: test
([email protected]) I need to extract only the portion in
parentheses.

Sirocco · Nov 10, 2003

Use one of the many string functions.

John Spencer (MVP) · Nov 11, 2003

Perhaps something like:

Left(Mid(SomeString,Instr(1,SomeString,"(")),Instr(1,Mid(SomeString,Instr(1,SomeString,"(")),")"))