So I have a table which includes various addresses some of which have se, ne, w, etc. The issue is that they all show up in lower case. If I use the proper formula then it only fixes the first letter. Is there a combination of an if ( ), search () and substitute () formula (rather than find and replace all of them) that I could use to replace all of the ne with NE and so on?

Thanks in advance.