tag:blogger.com,1999:blog-3693238014525650573.post4340135290391425664..comments2024-03-28T08:46:55.598-07:00Comments on News in Proteomics Research: Extract phosphopeptides from Proteome Discoverer outputUnknownnoreply@blogger.comBlogger1125tag:blogger.com,1999:blog-3693238014525650573.post-12916202004856883812013-08-15T23:16:31.173-07:002013-08-15T23:16:31.173-07:00This may have been cutting edge a few generations ...This may have been cutting edge a few generations of Excel ago but now there is a very simple solution.<br />1 - highlight your data<br />2 - go to the data window in the top menu. Apply filters. Little pull down menus will appear on top of each column<br />3 - in the modifications column, use the drop down menu to apply filters - text filters - Contains - "Phospho"<br />4 - all the data that does not contain the word phospho disappears. You can apply similar filters on any other parameter such as peptide score/confidence.<br /><br />Now the good part is that all the original data is still there, just hidden. However, if you select all the visible data, copy and paste, the information in the new spreadsheet is only those peptides that contain phosphorylation.<br /><br />I like the tattoo but these days you don't need to remember formula.Anonymoushttps://www.blogger.com/profile/03719891872408109903noreply@blogger.com