Uppercase formula?

clements55 · #1 08-20-2014, 06:42 PM

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.

excelledsoftware · #2 08-20-2014, 11:34 PM

have you tried the upper formula?

Code:

=Upper(a1)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hoe for force text entered into cell to be uppercase	Bob Gilmore	Excel	1	10-25-2012 05:48 PM
Auto Uppercase in preset form	MechEng	Word	1	07-20-2012 10:29 AM
find&replace word in uppercase with word in lowercase	andrei	Word	3	10-03-2011 05:11 AM
Day and Month to Uppercase	Andy2011	Word VBA	1	07-22-2011 04:34 PM
Help with Formula	Corca	Excel	6	02-22-2010 09:40 PM