"Rick Rothstein (MVP - VB)" skrev i en
meddelelse news:%
Another option:

=SUBSTITUTE(ADDRESS(1,COLUMN(INDIRECT(A1&"1"))+B1, 4),1,"")

Okay, I missed the direct addition... I see I didn't need the OFFSET
function call. I'll have to remember that... thanks for posting it.

I was going to remark on how much shorter your formula was than mine, but
once I removed the OFFSET function, I beat you by a couple of
characters.<g

=LEFT(ADDRESS(1,B1+COLUMN(INDIRECT(A1&"1")),4),LEN (A1))

Rick

Hey, this should have been the other way round. Me saying, that my
formula only has 4 function calls, and you answering: "Yes, but my
formula contains fewer characters!" <bg

Leo