Solved

Combine two formulas to format postal codes

+5

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?

Best answer by Pamela_Giles

ChatGPT knew how to do it:

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

+5

ChatGPT knew how to do it:

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

Sign up