change first letter of a word for an entire column

L

lori12844

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?
 
K

Ken Johnson

lori12844 said:
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?
Click to expand...

Hi lori,

with name in A1, try...

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

Ken Johnson
 
M

max power

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
 
L

lori12844

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?
 
M

max power

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
 
P

PlayingToAudienceOfOne

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
 
Top