Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change mixed case to upper case in Excel for all cells
I need to change name and address from mixed case to uppercase in the cells
on my Excel spreadsheet - is there a way to do this without retyping everything? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change mixed case to upper case in Excel for all cells
You could use a helper column and the formula =upper(a1) copied down.
If you wanted, you could then copy - paste special values back over the originals and get rid of the helper column. -- Kevin Vaughn "WordAlone Network" wrote: I need to change name and address from mixed case to uppercase in the cells on my Excel spreadsheet - is there a way to do this without retyping everything? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change mixed case to upper case in Excel for all cells
In a helper column, use the upper function. Ex: insert column B, then in B1
enter the function =upper(a1). Copy that formula down through the rest of column B. Now copy column B, select column A and Edit Paste Special, select Values and click OK. Then delete column B. Please save before making significant changes! And, personally, I'd ask if you really, really, really, want to convert to upper case. It's always easy to convert to upper case as necessary; not so easy to go back (and mixed case is certainly easier to read). --Bruce "WordAlone Network" wrote: I need to change name and address from mixed case to uppercase in the cells on my Excel spreadsheet - is there a way to do this without retyping everything? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change mixed case to upper case in Excel for all cells
Thanks - that will work just fine!
Anne "Kevin Vaughn" wrote: You could use a helper column and the formula =upper(a1) copied down. If you wanted, you could then copy - paste special values back over the originals and get rid of the helper column. -- Kevin Vaughn "WordAlone Network" wrote: I need to change name and address from mixed case to uppercase in the cells on my Excel spreadsheet - is there a way to do this without retyping everything? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change mixed case to upper case in Excel for all cells
Download a CaseChange add-in from http://www.xcelfiles.com/Downloads_01.html
"WordAlone Network" wrote: I need to change name and address from mixed case to uppercase in the cells on my Excel spreadsheet - is there a way to do this without retyping everything? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change mixed case to upper case in Excel for all cells
You're welcome.
-- Kevin Vaughn "WordAlone Network" wrote: Thanks - that will work just fine! Anne "Kevin Vaughn" wrote: You could use a helper column and the formula =upper(a1) copied down. If you wanted, you could then copy - paste special values back over the originals and get rid of the helper column. -- Kevin Vaughn "WordAlone Network" wrote: I need to change name and address from mixed case to uppercase in the cells on my Excel spreadsheet - is there a way to do this without retyping everything? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change mixed case to upper case in Excel for all cells
This is true. I frequently use the proper function myself.
-- Kevin Vaughn "bpeltzer" wrote: In a helper column, use the upper function. Ex: insert column B, then in B1 enter the function =upper(a1). Copy that formula down through the rest of column B. Now copy column B, select column A and Edit Paste Special, select Values and click OK. Then delete column B. Please save before making significant changes! And, personally, I'd ask if you really, really, really, want to convert to upper case. It's always easy to convert to upper case as necessary; not so easy to go back (and mixed case is certainly easier to read). --Bruce "WordAlone Network" wrote: I need to change name and address from mixed case to uppercase in the cells on my Excel spreadsheet - is there a way to do this without retyping everything? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change mixed case to upper case in Excel for all cells
Copy the following macro:
Sub Change_Case() Dim ocell As Range Dim Ans As String Ans = Application.InputBox("Type in Letter" & vbCr & _ "(L)owercase, (U)ppercase, (S)entence, (T)itles ") If Ans = "" Then Exit Sub For Each ocell In Selection.SpecialCells(xlCellTypeConstants, 2) Select Case UCase(Ans) Case "L": ocell = LCase(ocell.Text) Case "U": ocell = UCase(ocell.Text) Case "S": ocell = UCase(Left(ocell.Text, 1)) & _ LCase(Right(ocell.Text, Len(ocell.Text) - 1)) Case "T": ocell = Application.WorksheetFunction.Proper(ocell.Text) End Select Next End Sub "WordAlone Network" wrote: I need to change name and address from mixed case to uppercase in the cells on my Excel spreadsheet - is there a way to do this without retyping everything? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is it possible to change upper to lower case in excel | Excel Discussion (Misc queries) | |||
Loop for VBA code? | Excel Worksheet Functions | |||
Convert number into words | Excel Discussion (Misc queries) | |||
Change source text in Excel from all caps to upper and lower case. | Excel Discussion (Misc queries) | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |