excel Formula help !! - urgent

[ITCOM]

Hi. in excel i have a field xxxx (aaaa) , i want write a Formula to capture
aaaa information .

Thanks

 

[Guest]

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

 

[ITCOM]

Thanks help. Any way i tested does not work. my currect field as below.

BF BH
Email address Email display name
formula john([email protected])

I want write formula in BF field to capture BH colume (e-mail address removed) data.

Pls advice.

Thanks

 

[ITCOM]

THANKS. the error fixed

Thanks help. Any way i tested does not work. my currect field as below.

BF BH
Email address Email display name
formula john([email protected])

I want write formula in BF field to capture BH colume (e-mail address removed) data.

Pls advice.

Thanks

 

[Guest]

ALREADY answered!