MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula


Posted by IML on December 24, 2001 10:39 AM

=REPT(LEFT(ADDRESS(14,8,2))&LEFT(ADDRESS(23,15,2))&" ",3)


Posted by Aladin Akyurek on December 24, 2001 10:55 AM

Ian, Happy Holidays. -Aladin

Posted by IML on December 24, 2001 11:05 AM

Thanks Aladin, same to you. I'm sure your Christmas Turkey will be much more memorable than mine this year! Have a fun and safe trip. I thought you may propose a simplified formula such as

=SUBSTITUTE(REPT(ADDRESS(1,223,2),3),"$1"," ")

Posted by Aladin Akyurek on December 24, 2001 11:33 AM

> Thanks Aladin, same to you. I'm sure your Christmas Turkey will be much more memorable than mine this year! Have a fun and safe trip.

Thanks Ian.

> I thought you may propose a simplified formula such as

It's much nicer. I simply missed it. :)

Take care.

Aladin