Concatenate cells with 5 characters each column but ignore if blank

[ghiegomez08]

Hi All,

Good Morning! I'M In Need Of Help To Figure Out How To Concatenate Columns By A Dash With 5 Character Each Column But If The Column Is Empty The Formula Must Ignore Move On To The Next Column.


Columns A | B | C | D | E | F | G | H |

This Is How It Should Be Concatenated And Please Note The Length Value Inside The Column Should 5 So I Need Automatic Leading Zero If My Value Each Col Is Less Than 5:

COLUMN GROUPING: A-B | C-D | E-F | G-H

A | B | C | D | E | F | G | H |
BLK1 | BLK2 | BLK3 | | BLK5 | BLK6 | BLK7 | |

OUTPUT SHOULD BE: 0BLK1-0BLK2 0BLK3 0BLK5-0BLK6 0BLK7

Please Help!