|
|
|
|
#1
08-20-2014, 06:42 PM
|
|||
|
|||
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. 
|
|
#2
08-20-2014, 11:34 PM
|
|||
|
|||
|
have you tried the upper formula?
Code:
=Upper(a1)
|
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 8 
Office 2013
Hybrid Mode