Hi
@ EF
If I replace A2 with "eboard Regular", the result seems incorrect.
another option
=IF(ROWS(B$2:B2)>1,SUBSTITUTE(MID($B$1,ROWS(B$2:B2 )-1,1)," ","x"),SUBSTITUTE(MID($A$2,COLUMNS($B2:B2),1), " ","x"))
Hi
@ EF
If I replace A2 with "eboard Regular", the result seems incorrect.
another option
=IF(ROWS(B$2:B2)>1,SUBSTITUTE(MID($B$1,ROWS(B$2:B2 )-1,1)," ","x"),SUBSTITUTE(MID($A$2,COLUMNS($B2:B2),1), " ","x"))
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