Thread: [Solved] Uppercase formula?
View Single Post
 
Old 08-20-2014, 06:42 PM
clements55 clements55 is offline Windows 8 Office 2013
Novice
 
Join Date: Aug 2014
Posts: 1
clements55 is on a distinguished road
Default Uppercase formula?

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.
Reply With Quote