excel Formula help !! - urgent

[ITCOM]

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

Thanks

 

[Toppers]

=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 [email protected] 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 [email protected] data.

Pls advice.

Thanks

 

[Toppers]

ALREADY answered!