Finding a string within a string

[Sandra]

Let's say
A1 = aaaaaaa aaaaaaa ([email protected]) eeeeeee
A2 = aaa aaaaaaa ([email protected]) eeeeeee
A3 = aaaaaa aaaaaaaaaaa ([email protected]) eeeeeee


I want to pull out everything with the parentheses. I'm trying to figure
out how to do this with a combination of Left and Search commands but I'm
too stupid. HELP!

 

[JulieD]

Hi Sandra

if this is a "one off" situation another approach would be to use the text
to columns feature under the data menu
select your data
choose data / text to columns
choose delimited
untick tab, tick other type (
click finish
now select the column with
(e-mail address removed)) eeeeeee

etc
and repeat the above but use other & )

Hope this helps
Cheers
JulieD

 

[Frank Kabel]

Hi
=TRIM(MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1))

 

[Domenic]

=MID(A1,FIND("(",A1)+1,(FIND(")",A1)-1)-FIND("(",A1))

Hope this helps!

 

[Dave Peterson]

A non-formula option:

Select the column with the data
Edit replace
what: ( (open paren)
with: ) (close paren)

now your data looks like:
aaaaaaa aaaaaaa )[email protected]) eeeeeee

Then data|text to columns
delimited
by ) (type it in the other box)
Skip the leading stuff, skip the trailing stuff.

(work against a copy of the column if you need to keep the original)