LinkBack URL
About LinkBacks
I can't believe what wonderful experts are out there
Help Test Page-2.xls
I can't believe what wonderful experts are out there
Help Test Page-2.xls
Formula:
Please Login or Register to view this content.
Last edited by :) Sixthsense :); 11-10-2012 at 03:31 AM. Reason: Formula Tag Applied
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
=--trim(substitute(mid(left(a3;len(a3)-1);find("(";a3)+1;len(a3));")";""))
How does this work with different number of open btackets to closed brackets
try it my be this formula is better than before.
=--MID(A3;FIND("(";A3)+1;(FIND(")";A3)-FIND("(";A3)-1))
see attachment to compare with another condition.
=value(mid(a3,find("(",a3,1)+1,find(")",a3,1)-find("(",a3,1)-1))
=trim(mid(substitute(substitute(a3,"(",rept(" ",99)),")",rept(" ",99)),99,99))+0
Perhaps
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks