regex - How to build regular expression to find n ocurrences of "[########]" in a cell -

I have a large table that includes the code of the item as follows:

 < Code> "Description [#######]" (code is enclosed in "[]" and is composed of 8 numbers)   
 I have code and details in different columns Will have to be separated. The reason for Regex is that the above details are found in Excel formulas like: =  
  = IF (xyz, "description1 [1 ######]", "description2 [2 ######] ")   
 so that the end result should be:  
  column 1: = if (xyz, 1 ## # ###, 2 ######) Column 2: = IF (xyz, "description1", "description2")   
 Has anyone done something like that? I have found these answers to some extent related, but there is currently not enough information to circumvent the regex:  
  
 
  
 < This class simplifies the replacement by using 
 class = "post-  regExp  
 This code uses a different array on column A, in column B  
   
  sub-spliced ​​() retarded object Object Dim X as Dim ozragmax I LNGRO Long X = Range ([A1], Cell (Rows.Count, "A"). And (XLEP). Protect Formula Redeem X (1 to Ubuntu (x), 1 to 3) objRegex = CreateObject ("Vbscript.regexp") with objRegex.Global = True.Patrain = "" (\ w} (\ [) (\ d {8}) (\)) for "" "(X (LNGRO) , 2) = X (LNGRO, 1), "$ 3") X (LNGRO, 3) = Change. (X (1, ​​3) = x and all   (x, 1), "x" (LNGRO, 1), "" "$ 1"