Hello,

I work with ocean containers and they all have an ID. The ID exists out of 4 letters and 7 numbers.
When I copy paste a container number into a cell it is like ABCD123467. I want it to be displayed like this: ABCD 123 456-7
Is there a way to do this, so I don't have to put the spaces in it myself?

Thank you in advance