View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
George Slartibartfast George Slartibartfast is offline
external usenet poster
 
Posts: 2
Default Correction

Sorry. The full script is:
=LEFT((RIGHT(A1;(LEN(A1))-(FIND("(";A1))));(LEN((RIGHT(A1;(LEN(A1))-(FIND("(";A1))))))-1)



George Slartibartfast wrote:

Try this
14-nov.-09

Try this to get data from brackets. It works any data inside the brackets:

=LEFT((RIGHT(A1;(LEN(A1))-(FIND("(";A1))));F2-1)

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
Access Modifiers
http://www.eggheadcafe.com/tutorials...modifiers.aspx