Actually, I can't use mid, since that also returns text I still get quotes.
I'm really stuck, how do I nest the result without the quotes??? Please help!

"Aaron" wrote:

For the reference syntax of my offset formula I am using the Address
function. What I need is A1 but of course the Addres function returns "A1"
which means nothing to the offset function. how do I get the address formula
to just return A1? I suppose I could use MID, but is that the only way?