#1
|
|||
|
|||
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
|
|||
|
|||
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 |