I'm trying to format Canadian postal codes. Often the person enters them as k0e1b0. I need them to look like K0E 1B0.
UPPER({PostCode}) will make them upper case
REPLACE({PostCode},4,0," ") will put the space in the middle
How can I do both of these steps in one formula field?