ExcelBanter - Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula - Help !!! (https://www.excelbanter.com/excel-worksheet-functions/146852-formula-help.html)

ITCOM

Formula - Help !!!

i want write a Formula only capture aaaa information in test field xxxx
(aaaa)

Thanks

Toppers

Formula - Help !!!

Please don't start a new thread for the same question (which has already been
answered).

"ITCOM" wrote:

i want write a Formula only capture aaaa information in test field xxxx
(aaaa)

Thanks

Formula - Help !!!

If test field is A1
=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)

"ITCOM" wrote:

i want write a Formula only capture aaaa information in test field xxxx
(aaaa)

Thanks

All times are GMT +1. The time now is 05:31 PM.