I have a postcode column which goes like this:
AB21
G51
G5
CW9
I want to parse a new column in which there should be only be letters letters of that postcode, I have one below but it's only returning single letter and nulls,
please help
Thank you
Solved! Go to Solution.
Try a formula with REGEX_Replace([kpostcode],"\d","")
This will strip out all numerics from your string