Excel Reading Specific Data and Write to notepad in Specific Format -

at job have manually input lot of data in specific format on .txt file. gather data specific excel file. manually select number want column , copy txt file.

sometimes have 100's of rows @ time, rather time-consuming. if had access matlab i'd able write script me in matter of minutes, company doesnt have access it. have excel access.

so i'm looking writing sort of macro intensive work me. not sure how start, not experienced on this.

this data have on excel format:

excel data format

as can see, it's defined format every time. columns range n. need data column h , o. need every row present though.

the data needed circled around green. basically:

column h: itemkindindex[44557(

so first marker should start reading number, after '[' , ends on '('

column i: option[268440733[

data of interest between '[' , '['

column o: itemperiod[0]

data of interest between '[' , ']'

in case, need following numbers: 44557 , 268440733 , 0

then have them written in following format .txt file:

<itemserverdata itemkind="44557" itemoption="268440733" itemperiod="0" /> 

i have many lines 1 above many rows have on excel file.

i appreciate everyone's can chime in!

thank guys,

alexander

please use below formula in of empty columns , drag till end of list,

="<itemserverdata itemkind="""&(mid(a1,(find("[",a1,1)+1),(find("(",a1,1))-find("[",a1,1)-1))&""" itemoption="""&(mid(b1,(find("[",b1,1)+1),(find("[",b1,(find("[",b1,1)+1)))-find("[",b1,1)-1))&""" itemperiod="""&(mid(c1,(find("[",c1,1)+1),(find("]",c1,1))-find("[",c1,1)-1))&""""&" />" 

please replace a1 column h, b1 column , c1 column o. give exact string can use it. let me know if face difficulties.