VSC Code Formatting for Formulas?

[Pamela_Giles]

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?

[Pamela_Giles · Accepted solution]

ChatGPT knew how to do it: 

UPPER(REPLACE({PostCode}, 4, 0, " "))