Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 19, 2023 10:50 AM
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?
Solved! Go to Solution.
1 Solution
Accepted Solutions
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 19, 2023 01:43 PM
1 Reply 1
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 19, 2023 01:43 PM
ChatGPT knew how to do it:
UPPER(REPLACE({PostCode}, 4, 0, " "))
