No, I'll just rewrite the process as a macro.

I was just hoping to find a workaround for another Excel oddity. It would be nice to be able to write queries that can combine address information into one cell. But since XL won't cooperate, I'll just write a macro.

Thanks for trying.

Tom