Hello all,

I was wondering if someone already has bothered to program a macro/function with as argument a cell (or string), containing DNA sequence (e.g. GAATTCCGCCC) that return the reverse complement of that sequence (in this case GGGCGGAATTC).

Much obliged if someone can help out; or help me to build it ( total newbie in macros):
the macros should:
take the string (from a cell with valid input)
break it down into single letters
substitute for each
A > T
T > A
G > C
C > G
and then put the final string back in the reverse order
and return that string value to another cell