B Bo Nov 10, 2003 #1 How do I extract part of a text string such as: test ([email protected]) I need to extract only the portion in parentheses.
How do I extract part of a text string such as: test ([email protected]) I need to extract only the portion in parentheses.
J John Spencer (MVP) Nov 11, 2003 #3 Perhaps something like: Left(Mid(SomeString,Instr(1,SomeString,"(")),Instr(1,Mid(SomeString,Instr(1,SomeString,"(")),")"))
Perhaps something like: Left(Mid(SomeString,Instr(1,SomeString,"(")),Instr(1,Mid(SomeString,Instr(1,SomeString,"(")),")"))
