In excel can you change words from all caps to initial caps?
 

example instead of JOHNNY WALKER
I want it to be Johnny Walker.

In excel can you change words from all caps to initial caps?
 

Use PROPER(ref)

O2bardy wrote:

example instead of JOHNNY WALKER
I want it to be Johnny Walker.

In excel can you change words from all caps to initial caps?
 

=PROPER(A1)
--
Gary''s Student - gsnu200852

In excel can you change words from all caps to initial caps?
 

hi
assuming JOHNEY WALKER is in A2.
=proper(A2)

you can then copy the formula and paste special values in A2.
or if you have a column of names to converte, you might add a helper column
next to your name column. copy the formula down. then copy and paste special
values on the helper column - delete the original column.

regards


"O2bardy" wrote:

example instead of JOHNNY WALKER
I want it to be Johnny Walker.

In excel can you change words from all caps to initial caps?
 

Use =PROPER(A1)

Also just for information sake
=UPPER(A1) to convert to Upper Case
= LOWER(A1) to convert to Lower Case

--
If this post helps click Yes
---------------
Jacob Skaria


"O2bardy" wrote:

example instead of JOHNNY WALKER
I want it to be Johnny Walker.

In excel can you change words from all caps to initial caps?
 

"O2bardy" wrote:

example instead of JOHNNY WALKER
I want it to be Johnny Walker.

In excel can you change words from all caps to initial caps?
 

Hi
You can use =Proper(A1)
HTH
John
"wmca1932" wrote in message
...


"O2bardy" wrote:

example instead of JOHNNY WALKER
I want it to be Johnny Walker.

if you looking manually excel formulae, PROPER is the best option
for automated vba code, here you go

Sub AAA()
Dim myrange As Range
For Each myrange In Application.Intersect(Columns(1), _
ActiveSheet.UsedRange).Cells
Rng.Value = StrConv(myrange .Text, vbProperCase)
Next myrange
End Sub

all the best