|Here's a 2 step process:|
With your long string in A1, use the Data...Text To Columns feature to split the string into separate cells. If you use a semicolon ; and the bar | as your delimiters, you should get something like this:
A B C etc.
1 [I=406 A=5546.55 D=20110520 etc.
Once you have that, you can use this formula to extract the numbers after the equal sign:
Obviously, you would need to drag this formula across to update it for each column.
The MID function extracts everything after the equal sign and the SUBSTITUTE function eliminates the bracket at the end of the string if it exists.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.