Centre Across 2 cells with data in each

Hi, welcome to the forum.
What you're asking is not possible. You must understand that cell formatting does not change the cell's content.
A cell either has data or doesn't have data. Zo if you set the custom format to ;;; so hat is 'looks' empty, it's not.