Your question seems rather R instead of bioinformatics. It is likely someone will close your post for this reason. Additionally, you should let us know what have you tried so far.

i have list of txt file contain an information about protein molecule and i want to combine important information for all these molecule in one excell file to make it easy get only important information about these protien molecule lie accession number,chemical name mass ,wight

Please do not post additional information about the question as an answer. The answer field is reserved for an actual/potential solution that may help resolve the question. Also refer to: How To Ask Good Questions On Technical And Scientific Forums

these an information i need it from all files ACCESSION: BML82443* - CH$NAME

• CH$FORMULA: C23H24O9

AC$MASS_SPECTROMETRY: MS_TYPE MS1 AC$MASS_SPECTROMETRY: ION_MODE NEGATIVE AC$MASS_SPECTROMETRY: SCANNING m/z 100-1000

PK$NUM_PEAK: 1 PK$PEAK: m/z int. rel.int. 443.134756 240239 999 //

every sheet have 30 row and i need to convert important information into column for each file in final file

This is more a coding exercise than a bioinformatics question. Learn how to read files into data frames in R then how to combine data frames, how to subset a data frame and how to write a data frame to file. This is plenty of keywords to get you started on a search for tutorials.

By the way, don't post the same question multiple times. I've now closed the duplicate.

Hello islam.farag111!

We believe that this post does not fit the main topic of this site.

This is a pure R question. Please lookup utils::read.table, base::merge, base::rbind, base::cbind and xlsx::write.xlsx2 functions.

For this reason we have closed your question. This allows us to keep the site focused on the topics that the community can help with.

If you disagree please tell us why in a reply below, we'll be happy to talk about it.

Cheers!