Help

Combine two formulas to format postal codes

Topic Labels: Formulas
Solved
Jump to Solution
668 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Pamela_Giles
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

1 Solution

Accepted Solutions
Pamela_Giles
5 - Automation Enthusiast
5 - Automation Enthusiast

ChatGPT knew how to do it: 

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

See Solution in Thread

1 Reply 1
Pamela_Giles
5 - Automation Enthusiast
5 - Automation Enthusiast

ChatGPT knew how to do it: 

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