I have a column of names and I would like to change just the 1st letter of
each name to upper case-how do I do that?

lori12844 wrote:
I have a column of names and I would like to change just the 1st letter of
each name to upper case-how do I do that?

Hi lori,

with name in A1, try...

=UPPER(LEFT(A1,1)) & RIGHT(A1,LEN(A1)-1)

Ken Johnson

you can use the formula Proper

just type in a cell next to it =Proper(cell)

this will change all the text to have uppercase first letter and lowercase
for each letter after that

if your still unsure use the FX button next to the formula bar and sellect
the proper formula

regards max

"lori12844" wrote:

I have a column of names and I would like to change just the 1st letter of
each name to upper case-how do I do that?

Thanks..it worked great! can you answer my 2nd posting question which was

have entire column of addresses ie. 122main st and need to change to 122
Main St--is there a formula for this?

"max power" wrote:

you can use the formula Proper

just type in a cell next to it =Proper(cell)

this will change all the text to have uppercase first letter and lowercase
for each letter after that

if your still unsure use the FX button next to the formula bar and sellect
the proper formula

regards max

"lori12844" wrote:

I have a column of names and I would like to change just the 1st letter of
each name to upper case-how do I do that?

not sure what your after but if you are after changing the m in main to M and
the s in st to S than you can use the same formula

"lori12844" wrote:

Thanks..it worked great! can you answer my 2nd posting question which was

have entire column of addresses ie. 122main st and need to change to 122
Main St--is there a formula for this?

"max power" wrote:

you can use the formula Proper

just type in a cell next to it =Proper(cell)

this will change all the text to have uppercase first letter and lowercase
for each letter after that

if your still unsure use the FX button next to the formula bar and sellect
the proper formula

regards max

"lori12844" wrote:

I have a column of names and I would like to change just the 1st letter of
each name to upper case-how do I do that?

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


"lori12844" wrote:

I have a column of names and I would like to change just the 1st letter of
each name to upper case-how do I do that?