Thursday, 18 September 2014

Extracting Text Between Brackets

  1. There are times you will need to extract TEXT between bracket.
  2. Eg: (Userid) and extract userid to another cell.
  3. Use this formula below
    =MID(C2,FIND("(",C2)+1,FIND(")",C2)-FIND("(",C2)-1)