Hi
In C3 and copied down & across,
=IF(LEN($A3)=2,MID(REPT("-",$C$1-LEN($A3))&$A3,COLUMNS($C3:C3),1),MID($A3&REPT("-",$C$1-LEN($A3)),$C$1-COLUMNS($C3:C3)+1,1))
Hi
In C3 and copied down & across,
=IF(LEN($A3)=2,MID(REPT("-",$C$1-LEN($A3))&$A3,COLUMNS($C3:C3),1),MID($A3&REPT("-",$C$1-LEN($A3)),$C$1-COLUMNS($C3:C3)+1,1))
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
Posting Permissions
Reply With Quote
Bookmarks