How about this:
1) Insert a blank row1
2) Put GENE= in D1 and put LOCUS= in E1
3) Put this formula in D2, copy down and across to column E:
=IFERROR(SUBSTITUTE(TRIM(MID(SUBSTITUTE($B2, " ", REPT(" ", 50)), FIND(D$1, SUBSTITUTE($B2, " ", REPT(" ", 50))), 50)), D$1, ""), "")
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
wow! thank you so much
yes, it worked. I could collect the words in front of "GENE=" and "LOCUS=". Now I just have to use VLOOKUP function to compare them with my word list.
Is there any advanced tutorial that can help me to get familiar with these kind of advanced functions? I think I really need to learn how to use excel for these kind of tasks
Nazanin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks