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?

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?

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?

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?

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?

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?

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?

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?

[amays]

The best Excel Change Case Add-In can be found at the following link

http://www.nucleation.in/2012/07/change-case-excel-add-in.html

In this add in, change case functionality is incorporated to the context menu, which makes it very easy to use.

This Add-In has the following features
a. Change case of selected cells to ‘UPPER CASE’
b. Change case of selected cells to ‘lower case’
c. Change case of selected cells to ‘Proper Case’
d. Change case of selected cells to ‘Sentence case’
e. Change case of selected cells to ‘tOgGlE cAsE’
f. Customizable shortcut keys to perform change case actions