Hey all,
I am trying to search words that are in column A (5 letter combinations of sequences) within the text in column B (amino acid sequence).
So I am stumbling upon 2 questions (if anyone could take his time please):
- what is the function that would do this search.
- how to acchieve to reverse the text in B1 cell (eg. abcde --> edcba , but with 600 letters),
sample file:
test.xlsx
Thanks!
..anyone, please?
for the 1st question, use this, copied down...
=IFERROR(SEARCH(A1,D1,1),"")
For yoyr 2nd question, sorry, I have no idea
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
To actually search B1 for all 109 codes in column A, reverse them in the original string right where they are within the original B1 text, repeating the process as needed for all 108 column A strings... this would most likely need to be a macro, VBA.
A better sample workbook would have at least one match from column A inside the B1 string. I can't match any of them.
_________________
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!)
I am hoping that one of the link below works. You need to scroll down to the applicable topic about "Reversal"
http://www.cpearson.com/Excel/lists.htm#ReverseOrder
http://www.cpearson.com/Excel/VBAArrays.htm
Link quoted is from Chip Pearson's website
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks