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

Use PROPER(ref)

O2bardy wrote:

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

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

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.

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.

"O2bardy" wrote:

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

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