excel Formula help !! - urgent
 

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

Thanks

excel Formula help !! - urgent
 

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

"ITCOM" wrote:

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

Thanks

excel Formula help !! - urgent
 

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

BF BH
Email address Email display name
formula )

I want write formula in BF field to capture BH colume data.

Pls advice.

Thanks

"Toppers" wrote in message
...
=MID(A1,FIND("(",A1)+1,LEN(A1)-FIND("(",A1)-1)

"ITCOM" wrote:

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

Thanks

excel Formula help !! - urgent
 

THANKS. the error fixed

"ITCOM" wrote in message
...
Thanks help. Any way i tested does not work. my currect field as below.

BF BH
Email address Email display name
formula )

I want write formula in BF field to capture BH colume data.

Pls advice.

Thanks

"Toppers" wrote in message
...
=MID(A1,FIND("(",A1)+1,LEN(A1)-FIND("(",A1)-1)

"ITCOM" wrote:

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

Thanks

excel Formula help !! - urgent
 

ALREADY answered!

"ITCOM" wrote:

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

Thanks