Formula - Help !!!

  • Thread starter Thread starter ITCOM
  • Start date Start date
I

ITCOM

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

Thanks
 
Please don't start a new thread for the same question (which has already been
answered).
 
If test field is A1
=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel Formula help !! - urgent 4
Text formula 6
average based on criteria 7
Duplicates are GOOD: How to find the most duplicated values? 1
is there a way? 1
Numbering Duplicates 1
Filling in some blanks to a data table 3
How to remove duplication in text string? 1

Back
Top