Using Proper(), but leave uppercase characters, like NW, SW etc

[Sighman]

Hi,

Wanting to use Proper() to tidy addresses but it changes NW, SW, NE, SW etc. to Nw, Sw, Ne Sw, is there is a function to keep uppercase words like that but correct the rest?

[v-xiaochen-msft]

Hi @Sighman ,

Powerapps does not have a similar function.

You could use Proper() function first then use Substitute() function .

This needs hardcode to save the address.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

[Sighman · Accepted solution]

Unfortunately substitute() won't work as it tends to mess up other words...eg. 23 Swift Lane will end up as 23 SWift LaNE....

I was hoping to not have some massive if() statement using endwith()...but that looks like my only solution