Replacing a section of the data in a cell for thousands of excel data -

i have large spreadsheet column data like:

abc:1:i.0 abc:1:i.1  abc:1:i.2 abc:1:i.3 abc:2:i.0 abc:2:i.1 abc:2:i.2 abc:2:i.3 abc:3:i.0 abc:3:i.2 abc:3:i.3 abc:4:i.0 abc:4:i.1 abc:4:i.2 abc:4:i.3 abc:5:i.0 abc:5:i.1 abc:5:i.2 abc:5:i.3 etc. 

i need replace above following:

abc:i.data[1].0 abc:i.data[1].1 abc:i.data[1].2 abc:i.data[1].3 abc:i.data[2].0 abc:i.data[2].1 abc:i.data[2].2 abc:i.data[2].3 abc:i.data[3].0 abc:i.data[3].2 abc:i.data[3].3 abc:i.data[4].0 abc:i.data[4].1 abc:i.data[4].2 abc:i.data[4].3 abc:i.data[5].0 abc:i.data[5].1 abc:i.data[5].2 abc:i.data[5].3 etc. 

here sample of data, of data follows similar format exception of naming "abc", can vary in size, might "abcd" , exception of letter "i", can "o" well. also, might missing values such abc:3:i.1 missing data. not familiar excel formulas or vba code. know how this? have no preference on method has done in don't mind learning vba code if provides me vba solution.

i thinking of using sort of loop along conditional statements.

thanks!

please try:

=left(f11,find(":",f11))&mid(f11,find(":",f11,6)+1,1)&".data["&mid(f11,find(":",f11,2)+1,1)&"]."&right(f11,1)   

copied down suit, assuming placed in row11 , data in columnf starting in row11.

---

curiosities:

1. when first posted attempted address tabulated example input , output. temporarily deleted version while addressing in table abc might @ times abcd , i might @ times o.
2. op has posted answer edited make no visible change shows deletion of 2 characters. copy of op’s formula exhibited syntax error prior edit.
3. op suggested edit answer rejected review process. happens, think edit suggestion incorrect.
4. i have edited answer again include these ‘curiosities’ , match cell reference used op in answer.